Hello

I have a sheet with the following in Cells A1 to E1.

BIG_TANK_CO_20110101-00.XLS
BIG_TANK_CO_20110102-00.XLS
BIG_TANK_CO_20110103-00.XLS
BIG_TANK_CO_20110104-00.XLS
BIG_TANK_CO_20110105-00.XLS

These are all external sheets that hold data for each day for the month of November.

Under each of these I want to have date headings and under the headings put a formula that looks at the respective tank spreadsheet and brings back the value in cell B16.

So if the headings are in Row 2. A2 would be 01/11/2010 and A3 would have the value of B16 from sheet BIG_TANK_CO_20110101-00.XLS.

Now the complexity is that I have 6 months worth of sheets so I need the formula in A3 to change dynamically. So I should be able to copy the formula from A3 into B3 and it will look at the sheet name in B1 and use this when returning the value for B3.

Hope this makes sense.
Thanks
Ed