I have been asked to create a workbook that consists of approx. 70 different sites, each with their own sheet, that ppl can use for equipment tracking and projects.
I have a "master" sheet with all of the sites and their assets and a pivot table summarizing the data from this "master" sheet. That seemed perfect for the purposes of equipment tracking,etc...
Then came the request for each site to have their own separate sheet that they can modify, update, etc, which will render the "master" sheet essentially useless.
What I need is a pivot table that will show the same data I was summarizing from the master sheet, except it will need to come from the 70 separate sheets.
Any tips or feedback would be greatly appreciated.
TIA
I have a "master" sheet with all of the sites and their assets and a pivot table summarizing the data from this "master" sheet. That seemed perfect for the purposes of equipment tracking,etc...
Then came the request for each site to have their own separate sheet that they can modify, update, etc, which will render the "master" sheet essentially useless.
What I need is a pivot table that will show the same data I was summarizing from the master sheet, except it will need to come from the 70 separate sheets.
Any tips or feedback would be greatly appreciated.
TIA
