Hi,

If I have the address, file name, sheet name and cell ref of a source file
typed into cell A1 is there a way in which I can use the text in cell A1 as
an address to drive an = formula?

I only want to copy the data in one cell, the same cell ref in every folder.
In the results file all I need is an =(reference) formula.

The reason I would like this is to save me having to recreate a lot a lot of
references (one for every day of every year).

It will always be the same cell ref in every single file and sheet. The
address type is in the form of:
Network/Directory/Sub directory 1/Sub directory 2/ Sub directory 3/Sub Dir 4
(Year)/Sub Dir 5 (Month)/File name/Sheet

Example addresses contained within col A are; (to find data in G12, on 3 Mar
et 15 Apr 2009 from the plastic cartons from UK)

C:/UK/Cartons/Plastic/Results/2009/3/ Production results Mar/3/G12
C:/UK/Cartons/Plastic/Results/2009/3/ Production results Apr/15/G12

In col B I would like something very simple, just an = before the address
above that will return the data within the cell.

The idea is then if want to change the address I change UK fro France and it
automatically searches a different folder.

Is it possible to drive an address from the contents of a cell?

Thanks
LiAD