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.

At the moment I use the following formula:

{=INDEX('01-01-2004'!$D$2:$D$8,MATCH(B4&C4&D4,'01-01-2004'!$A$2:$A$8&'01-01-2004'!$B$2:$B$8&'01-01-2004'!$C$2:$C$8,0))}

Which works fine but it only looks for the data on worksheet 01-01-2004.
Now I would like to add a fromula to this formula so I can get the data of
the other worksheets if A1 is equal to the name (=date) of the worksheet.

Can you help?

Thanks in advance.

Deborah