I have 3 different worksheets, "01-01-2004", "01-11-2005", "01-01-2006".

In a separate spreadsheet I want to insert a formula that gives me data from
the worksheet I specify.

e.g. In cell A1 I insert the date of the worksheet I want to use, e.g
01-01-2004.
I want to find a formula that looks for the worksheet dated 01-01-2004 and
gives me the data that is in cell B7 of that worksheet.

Can you help?

Thanks in advance.

Deborah