I´m having a problem about linking a few workbooks to one, my idea initially
was that i can separate the reference, lets suppose my formula goes this way:

VLOOKUP($A1,'C:\INFO\MONTH\[REPORT MONTH.xls]Sheet3'!$B$4:$J$158,$A39,FALSE)

Now my idea is that if I have a several number of months saved in a folder
with the name of the month, then I can referentiate the month in a column,
lets say I could do something like this:

=Concatenate("'C:\INFO\","B5","\[REPORT","B5",".xls]Sheet3'!$B$4:$J$158")

Where the value of B5 is (January, February.... or anymonth) plz

BUT!!!!!!! This is not working so I would really appreatiate some help with
this cuz i think this will solve a lot of problems.