I saw this in another post and I thought that if it was reworded, it might
make it easier to understand. In the formula below, at the point where it
says "Book2.xls", I was wondering if there would be a way to have "2"
designated by the contents of a cell in the current worksheet. For example,
A1 contains 2. It could be any number, but I want the file reference to
change based on the contens of A1. Is this possible?

='C:\temp\[Book2.xls]Sheet1'!$D$1

Thanks,
Paul