Use INDIRECT to dynamically refer to worksheets in Excel and ...

In this case, you can use the INDIRECT() function, which is available in both Excel and ... can't use a reference to D1 to specify the sheet we want in our VLOOKUP() function like this: ... Indirect() in Excel.

spreadsheetpro.net