[Closed - No Resolution] Lookup Formula Question

I am looking for help on a formula.

I have a two worksheet file.

On one worksheet I have every day of the year (work day) and corresponding data for many topics for that day in the column.

On the other worksheet I want the user to type in a date and have the data for that day from the first worksheet display in a specific cell (based on the date entered at the top of the sheet) on the second worksheet.

I think it is some type of lookup formula but am not sure. Any ideas?

Again: Enter todays date on one worksheet and have data display based on that date from a second worksheet. The data on the second worksheet would be manually updated every day.

Thanks and I look forward to any help.