Is there a way to use an excel tab to store others? not consolidating data

Copper Contributor

Hi,


Let me elaborate, I'm working on a file that has a "master sheet" and approximately 51 other sheets that draw data from it, and the number will keep increasing. Hence, I'm looking for a way to "store/group", not consolidate because the data is different in each sheet, these tabs in a single one to avoid clutter, so that, when i click this new tab/sheet it will show or hide the other ones.

 

And, if so, would this whole process interfere with the links I've putting in all sheets?

Best,

Euler

0 Replies