Hi, I am having problems trying to dynamically link files to my main files.

In my Main file I have a cell that is linked to another workbook. For
simplistic sakes lets say cell A1. The formula in A1 is
='H:\Files\[073109.xlsx]Backup'!$A$1.

- So no problem here. Whatever is in my 073109.xlsx file on the Backup tab
in cell A1 will populate my other A1 cell.

I want to make my main file dynamic so that I can change the reference file
on the fly. To do this I put in a variable cell in B1 in my main file that
the user can input the date of the file.

- In A1, I now put in the formula
=concatenate("'","H:\Files\[",B1,".xlsx]Backup'!$A$1")... if I put 073109
into B1 then I get the following in cell A1
"='H:\Files\[073109.xlsx]Backup'!$A$1"

The problem is that it just shows the text instead of actually retrieving
the data in that file. I need it to show the result not just provide the
string?

Any ideas?