Hi,

I am trying to retrive data from variable workbooks based on the value of a
cell contained in the receiving workbook for example

Cell B1 contains the text "June"
I would like to return values from the workbook saved in C:\.....\june.xls
and extrapolating on that if I enter August in B1 I want to retrieve data
from C:\....\August.xls

Any help would be greatly appreciated

Thanks in advance