Hello users.

I'm trying to figure out a way to dynamically reference file names that have
different months. I am trying to do the following:

There is a master file and many slave files (organized into months).
Master.xls wants to vlookup data corresponding to date from corresponding
month file.

Example:
A B
1/1/2009 -- Vlookup from "Jan 09.xls" column one to find 1/1/2009 and
return Column B

Inside Master.xls file, I extracted each file extension ("Jan 09", "Dec 10",
etc) in column Z to reference.

So then I used this formular to start the dynamic referencing:

=vlookup($A1,INDIRECT("'[C:\...\"&$Z1&".xls]Sheet1'!A:B"),2,0)

This results in a #REF but it seems the
INDIRECT("'[C:\...\"&$Z1&".xls]Sheet1'!A:B") segment of the formular should
work fine. I'm not sure. Am I missing something? Could someone help me out
here?

Many thanks in advance.