You can use INDIRECT but it only works if the other file is open.
Otherwise you would need to download and install an add-in like Morefunc

http://xcell05.free.fr/morefunc/english/#Download

look at indirect.ext


--


Regards,


Peo Sjoblom


"frustrated linker" <frustrated wrote in
message ...
I'm trying to link from 26 separate but identically formatted files to
pull
in similar data. I want to use a single formula, but swap out the
filename
based on the value I put into another cell. Anyone ever done that? I
keep
trying but can't get past the formula error checker... I was working with
26
different formulas but need this flexibility to adjust to the amount of
data
I need to collect from each file.