I can't upload it as it is a work file.

"There is a pivot table. When you double clicking on the “Grand_Total and “Grand_Total” cell in a pivot table a new sheet is created containing the data from the pivot table.

Part of my question is how to handle the issue of every day the pivot table creates a sheet of data it uses a different name.

Perhaps you can create a pivot table to see what I am talking about."