How do you control worksheet naming of detail from a pivot table?
 

I am attempting to create separate worksheets in a workbook to represent the
showdetails feature of a pivot table and trying to name the worksheet with
the
row pivot value or the column pivot value depending on which total cell is
selected.
I can rename it after the fact to the row or the column but the automatic
naming goes SHeet1, sheet2,sheet3, etc when doing the showdetail. The sheet
naming of the detail is not readily conducive to looping in a macro down
thru the pivot table to pick tha row or column names to become the worksheet
names.