Use Cell data to link to another file

[mtbe]

I have the following formula that grabs data from cell C24 in another Excel File:

='O:\PRODMONTH\Production2013\[fw38_13.xls]Mon'!$C$24

The bold value, 38, is also a value in the current file's cell, A261. How do I incorporate that cell data into the filename in the equation?

The next line, same equation, but would be ='O:\PRODMONTH\Production2013\[fw39_13.xls]Mon'!$C$24, with the 39 coming from cell A262...

Also, B261 contains the date. Is there a way to change the text on the "MON" tab (also in bold) based on the date field in B261? For Example, to Mon, Tue, Wed, etc...
The next line, same equation, but would be ='O:\PRODMONTH\Production2013\[fw38_13.xls]Tue'!$C$24, the the TUE coming from the date field in B262

[FDibbins]

You can probably do this using the INDIRECT() function, however, it does not work with closed files To get it to work with closed files, you will need to download and install the MoreFunc add-in