I have 100 plus sheets in a workbook.
Each has the same layout for data entry.
Each sheet tab is the name of an employee.
In (B1:B10) I enter a date.
In (C1:C10) is data I need to display on a master sheet called "Roster".

The Roster sheet in A13:A20 will contain the names of employees as an example.
A1 in the Roster sheet will have the current date.
How can I match the name in A13 of the Roster with the Date in A1 of the
Roster and return the corrosponding data by date from the worksheet of the
employee in A13. This value is displayed on the Roster sheet in B13.

I am stumped.

Thank you,
Martin