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.