I am working with a large data source with sensitive information. After creating a pivot with this data source I "show pages" to create pivots for many separate groups. The problem I am running into is that, due to the sensitivity of the data, I need to restrict access so that for each group pivot I create with the "show pages" can only access their own data.
I found a Macro that will disable selection, however, if the user copies the worksheet, the ability to select is enabled again. Also, because of the sensitiity of the data, I need to ensure that there is no way for them to be able to manipulate to retrieve other data.
Essentially I need to "show pages" and then have the new pages access or reference their own data instead of the original data.

Any ideas? I'm counting on you. I'm definitely having a blonde moment.

Thank You!