Hi guys...

Ok each month i recieve a excel worksheet which contains data which i need
to consolidate with other familiar sheets...

In my consolidation schdeule what i normally do is painfully copy and paste
each section of data from the first workbook into the consolidation
workbook...

Now i wanted to create a formula which just links to the first workbook from
the consolidation workbook, this is obviously done by clicking and linking
the two, giving me a formula in each cell eg.
T:\Folder\Folder\Folder\2009 - 2010\[Aug 09.xls]Sheet1!A1

Now i wanted to ask if this pathway can include references to cells so that
when i change the date to 'Sept 09.xls' in cell A3, the pathway will change
to the Sept 09 file and pick those numbers automatically...
E.g. T:\Folder\Folder\Folder\2009 - 2010\["A3"]Sheet1!A1

I hope what im trying to ask for is clear.

Thanks