NoSparks.

Using the macro recorder is what I started doing. The problem is every time I double click on the “Grand_Total and “Grand_Total” cell When it creates the new sheet it gives it a different name. The next steps in the macro need to get the data from this newly created sheet. Tough to repeat when it is always a different name!

When I click on the sheet with the pivot table in it, right click and select view code there is no code there.

Pecoflyer

The pivot table normally doesn't change, only on rare occasions. The data in it every day does change.