Super simple. This macro uses the ⌘T long press (when Excel is at the front) to turn the current region into a table (any selected cell within a region is fine, you don't need to grab everything), and then asks Excel to create a new pivot table on a new sheet from that filter table.
This just speeds up something that I do frequently in my work.
Summarise with Pivot Table Macro (v10.0.2)
Summarise with Pivot Table.kmmacros (3.7 KB)
