There is no macro yet so I can't upload it.

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.