you can try indirect

this looks at cell b8 and then goes to that sheet name, cell i7 and returns the
value

=INDIRECT(B8 & "!$I$17")

--


Gary


"Kaby" wrote in message
...
Is there a formula that I can put in a cell that tells excel to match part of
the file name that I will provide for it in an adjacent cell, go into the
file and link the data to the destination file.

Thanks.