Formula getting data from sheets with different names

Occasional Visitor

Hello, I have a file with 12 different sheets (one for each month) that all have the same format. I’m creating a new sheet with graphics. To feed this graphics, I created a table (on this new sheet) that gets data from page Jan23, for example cells A5, B5 and C5. So the cell on the new page says: ‘Jan23’!A5. I also have a drop down list (on this new page) with the names of all the 12 pages (12 months). What I wanted to do is that the cell that has the formula (‘Jan23’!A5) could replace the name of the sheet by the one I select on the drop down list. Is this possible to do?

1 Reply
best response confirmed by Biabaldaque (Occasional Visitor)



You can try this formula which is in cell B5 and copied to the right. The data validation is in cell B9 and the reference list for data validation is in range A9:A20.

Formula getting data from sheets with different names.JPG