HELP! Is it possible to copy data from one cell to another cell when today = certain date/month?

[DHark5454]

Hello, 

I am looking for a solution to automate the retrieval of data from a cell at a certain point in time. I would like the value in the cell to be copied and permanently pasted to a different sheet when dates change. I have added pictures and highlighted the cells I am looking to use. Please Thank you in advance for any feedback. 

Thank you,

Devon

[#2]

Try using VLOOKUP like this =VLOOKUP(TODAY(),A2:B12,2) This formula will look in column A from cell 2-12 for today’s date and get the value from column B in the same row.