Help with paste link cells

[Alpacino]

I have a file that gets info from other workbooks in sheet3 I have table that gets info from (Eg) AlanWk3.xls cells B4:AC35. I know how to paste link the cells how ever this file changes each week and the AlanWk_.xls changes as well I like to insert a cell with wk number so yhat the paste link formula will adapt with it Eg if it's wk 27 and I put 27 in cell A1 then cell formula would be
='[AlanWk27]'Sheet1!B4
And then all relating cells B4:AC35

Thanks

 

[Robert Mika]

Look here:
http://support.microsoft.com/kb/151323

It may help.

 

[Alpacino]

This would not work for me cos the file has to be open for this to work. Any other ideas??? Anyone