Just to clarify.
The trick is to use Excel's capacity to create sheets from a Pivot table.
People are frightened of Pivot tables but they don't bite.

When Excel has finished creating the sheets, you just join all the sheets
together and zap the rows containing the PT. And then unjoin them. So you
have a new pile of clean sheets!

Andy