Try this:

Enter this formula in Roster B13 and copy down as needed:

=VLOOKUP(A$1,INDIRECT("'"&A13&"'!B1:C10"),2,0)

--
Biff
Microsoft Excel MVP


"Trying to Excel" wrote in message
...
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