You can exactly create the same circumstance by creating a pivot table. When you double click on the Grand Total/Grand Total intersection cell it creates a new sheet. When you do it again, it creates a new sheet with a different name.

I want to create a macro that does all of this automatically. It is difficult when the name of the new sheet changes every time.