I have a spreadsheet, in one worksheet I have a row of dates, then below a
row of data.
A,B,C (Columns)
1 01/01,01/02,01/03 (Rows with Dates)
2 100,200,300 (Row with Data)

On another worksheet I have a cell that I want to populate based on the
previous worksheet's data, but only if the date in column 1 equals today's
date.

So if today's date is 01/01 the cell would populate with 100. If today's
date was 01/02 it would popualte with 200, etc.