getting data from sheets that don't exist yet


I'm making an excel sheet for work to total invoice costs, and i have it all pooling to a master sheet. what i would like to be able to do is have the master sheet setup in such a way that it can automatically pull new data from the sheet that may be created in the future, without having to do all the formulas manually when i make the new sheet

1 Reply
best response confirmed by Bakuscout (Visitor)

Hi @Bakuscout 


you could place the name of an existing sheet in one cell and use in all your formulas the INDIRECT function with a reference to that cell.


In my screenshot, you but "Sheet2" in cell B1 and the formula in B3 is working fine, because Sheet2 exists already.



When you later get the real sheet name, just replace the name in cell B1: