How to get the data sheet tab from a pivot table sheet

[vbanovice123]

Hi

I want to generate a new data sheet tab from another sheet tab that has the pivot table data.

Lets say for example I have a all the data from the database exported to excel. I call the sheet RawAgencyDBData. I create a pivot table based on this data in another new sheet within the same file. I call this Agency_Data.

I want to create another tab called Agency. I have other tabs in the file that already are generated from other pivot tabs in the file. This was already done by someone else. When I click on each value in the data sheet tab, I notice formulae like =IF(ERROR GetPivotData) and so on.

Does it make sense to copy the existing data sheet tab in the new Data sheet tab I want to creat and then change the reference in the formula to point to the new pivot I created?

Thanks for your help