SOLVED

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

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:

1 best response

Accepted Solutions

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:

View solution in original post