Importing data from other Excel files

**kbarnes821112** · 01-19-2007, 01:11 PM

I have a VLOOKUP function that pulls data in from another spreadsheet. Every month when I need to update the data, I have to manually change the name of the source eg:

VLOOKUP(A1,'C:/Excelsourcefile - Jan07.xls'!A1:E32,2,False)

changes to

VLOOKUP(A1,'C:/Excelsourcefile - Feb07.xls'!A1:E32,2,False)

This needs to happen in many cells in many sheets.
Is there a way to point the vlookup to one cell in this workbook, that contains the file name (C:/Excelsourcefile - Jan07), so that all I need to update is that cell?