Hi,

Question: Ho do I replace an external tab name with the value from an internal cell?

Situation: I want to get cell values from another Excel file, but want to be able to change from what tab the values come from. In my case the tabs is named by the year: 2020, 2021, 2022, 2023 etc.

The link now is:

=[database.xlsx]2022!B3
I would like to replace "2022" with a the value (2022) from a cell (A1) from the same (internal) sheet. Something like:

=[database.xlsx](A1)!B3