I have a workbook a coworker made which shows us our monthly booking $ and %, sales $ and % as well as backlog $ and %. There are two sheets, one shows information for every work day in the month, the second one is for the current date. I am trying to find if there is a formula I can apply to say something like:

If cell A1 = the current date, then cell A2 on sheet 2 = cell A2 on sheet 1

Is that even possible?

I know someone can just copy and paste the information on a daily basis, but I wanted to see if I could make it simpler.