Designate Which Sheet to Call Upon by Cell

**summoner49** · 02-17-2019, 11:41 PM

Hello all!

I am trying to develop a workbook that will save me time doing some basic work calculations that I'm required to do monthly. However, I also would prefer to keep all of my historical work saved in the same workbook for reference.

So, I have two master sheets, one is for data dump, the other is to call upon the information that is dumped in my data dump sheet. So, at the bottom of my workbook, over time, it will have a significant number of sheets to scroll through... ie Period 1.... Period1Data... Period 2... Period2Data....Master... MasterData.

Considering I want to be able to copy my two master sheets, but I want them to be used as a pair, is it possible for me to have a cell in my Master sheet that signifies the name of the Data sheet to call upon?

For instance, if I have Period 1 and Period1Data, can I make a cell in Period 1 that just has the words Period1Data, so that the cells that need to link to the Period1Data sheet know which sheet to pull from? And I could keep copying Master and MasterData and simply update this one cell so that the formulas all update?

This would save a ton of time if this is possible. Perhaps there is another way all together that I don't know about?

I appreciate your time and help with this.

Landon

**FDibbins** · 02-18-2019, 01:32 AM

Hi, welcome to the forum

Yes, you can do what (I think) you want to do using INDIRECT()

However, I think your entire concept/approach could be vastly improved on.

If you have all your data in 1 sheet anyway, why repeat that same data on anther sheet? If you already have all your data being gathered on 1 sheet, you can then use 1 (or more) sheet to do your extracts and summaries, based on whatever vriteria you have.