=indirect("[Wss.xls]WSS" & BU1 & "!D77")

but WSS.xls must be open.

--
Regards,
Tom Ogilvy

"chartasap" wrote in message
...
Is there any way to have a 3d reference such as the following:
=[Wss.XLS]Wss711!$D$77 reference a sheet whose label will change. Sheet
Wss711 will change depending on the date. I've added the dates (i.e. 711,
712, 713, 714, etc) in column BU. Is there any way i can modify the 3d
reference so that it looks at spreadsheet Wss.xls sheet Wss[BU1 or BU2,
etc)
depending on the today's date (will be using 3 - 4 digits for the day -
i.e.
711 or 1211).

Thank you.