Disclaimer: I'm very much a novice to VBA.

I'm trying to take a pivot table that I have made and create a macro that you can use to highlight any cell in the pivot table so that it will open the detail and then create a new more detailed pivot on that detail only.

Essentially I have about 5000 data points that fit into all of these different categories, too many to list on one pivot and have it be useful, but it is useful to drill into one particular data set of say 30 points and make a very detailed pivot from that data. If anyone can guide me as to how to create a pivot table on a new sheet from the original pivot table, I'd appreicate it.