Daily Updating an Excel from another whose name Changes daily

Originally Posted by winkblink

Hi,

I have an Excel sheet (say Static.xls) which takes in input from another sheet (say Today_is_15.xls). Both these sheets have formatted data. However, the File "Today_is_15.xls" is updated daily and subsequently its name also changes to "Today_is_16.xls" and so on.

Now I don't want to keep linking the file Static.xls with the file "Today_is_XX.xls" on a daily basis. Is there a way, wherein I can just change the filename somewhere (say I store it as text in some cell of "Static.xls") and the Links in "Static.xls" take that name as filename?

Thanx,
Wink Blink

try INDIRECT function

=INDIRECT("["&A2&".xls"&"]"&"Sheet1!$A$1")

where A2 contains workbook name. when you enter workbook name in A2 this function will return value from sheet1 cell A1 of that workbook.
you can amend references according to your requirements.