I inherited a spreadsheet where the user can select 2 inputs from dropdown lists, and by using INDIRECT, the required named data range is selected and reported. Which works fine.

However, the workbook has become too big, so I’ve split the individual data pages from the workbook into separate new workbooks, but, now INDIRECT will only work if the relevant data workbook is open and there are currently 16 of them!. Is there a way I can access the data without having to open the individual data workbooks?

Any help would be greatly appreciated.