Alternative to "INDIRECT"

Hi, I was just wondering if anyone had a possible alternative to the indirect function.

I am using it to refer to cells in other workbooks. The reason I am using INDIRECT is because each column on my workbook relates to a different sheet in the other workbook depending on the week number.

The problem I have with the function is a common one - doesnt work when the other workbook is not open. As I will be referring to a number of different workbooks and will have multiple users of the workbook, this is not practicable.

Contents of cells in my workbooks:
S73: =INDIRECT(S$67)
S67: ="'C:\Inbound Subs\Daily Stats\[Daily stats 2011.xls]"&S14&"'!$a$4"
S14: "Week 18"
[i.e I need the value of cell A4 from the 'week 18' sheet of the 'daily stats' workbook in cell S73 of the current workbook]

Similarly, in column T, I have the same formula in rows 73 and 67, but the value in cell T14 is "Week 19" because the cell value I am trying to retrieve is in the sheet called "Week 19" in the 'daily stats' workbook.
[i.e I need the value of cell A4 from the 'week 19' sheet of the 'daily stats' workbook in cell T73 of the current workbook]


Does anyone have any kind of suggestions (apart from manually changing 52 references)?

Thanks
Karen

Thanks guys - I will try a macro.

I thought I would report that a Macro was too much for me so what I did was:

Copy value of S67 across so that the week number incremented.
Copied those cells and pasted special values into row 73 and then did a find and replace to place an '=' sign at the beginning of each cell which turned it into a formula.

Not as dynamic as I would have liked, but it did the job.

Thanks again for your help.