Pivot Table Question
 

I created a Pivot Table that works great. I have a question. When I double
click on the count of a particular field, it creates a spreadsheet of the
detail which is fine. Is there a way programatically name the worksheet
something, i.e. Column A of the cell I click on.

For example,
ERR OPN CLS
Johnson 1 3 2

When I double click on the number 1, it names that tab Johnson.

Thanks