I have a workbook with 173 references to an external workbook (for simplicity referred to as Source.xls). The workbook has a cell C2 that also references the various spreadsheets in the workbook ranging from 104 to 120. I am looking for a solution to dynamically change the below vlookup as the cell C2 changes within the range from 104 to 120. I tired to program the reference as a CONCATENATE("'[Month to Month Spreadsheet Template.xls]",$A$1,"'!$B$4:$DS$11") and manually with &, but the vlookup did not properly reference the range.

Here it the base formula for the vlookup: VLOOKUP(F13,'[Source.xls]104'!$B$4:$DS$11,22,0).

It is critical for this formula to work when the Source.xls is not opened. Thank you in advance for your assistance.