I have a reference to an Excel table in another sheet, like this:

='Day-Out-17-HYS.xlsx'!TblSmmry[[#Totals],[Date]]

and would like to replace the HYS above with a cell reference such as B17 so that copying this formula to other rows would access different external sheets.

I've tried various combinations of "&B17&" with/without double quotes around the sheet name, but haven't yet found the right way to do this



i.e. ="'Day-Out-17-"&B17&".xlsx'"!TblSmmry[[#Totals],[Date]] and other variations get There is a problem with this formula error.