Simple Edit for Multiple File Reference?

Is there anyone that knows a way to reference a cell to another file by use of another cell that contains the name of the filename/path?

Typically a formula that references another file might have something like this within it: 'C:\Documents and Settings\All Users\[Book1.xls]Sheet1'

If each month "Book1" is changed in succession, instead of changing 1000's of formulas to say "Book2", "3", "4" etc., how about a cell on the spreadsheet where the formulas rest that you could type in "Book75" and the formulas would follow suit.

Is this just fantasy?

Thank you in advance.