I need to know how to link two workbooks when the name of one of them will be
constantly changing. One workbook will be used to track productivity and
provide some analysis while the other workbook, the one with the changing
name, will be payroll file that lists how many hours each department worked,
wages, OT, etc.

So I will name the data file for the last day of the week and have files
named 06JAN2007, 13JAN2007, etc. So instead of just hitting the = sign and
linking to two workbooks I want it to look for the name of the workbook in a
cell somewhere so that all I have to do each week is change the file name in
the reference cell.

Any idea on how to ask it to get the info from a file that is named in a
cell on the current worksheet?