show detail in pivot table

Hai
i am using excel 2007 and i have a doubt in using show details in pivot table

i am having a data with names and amounts
i had created a pivot table with names in row lables and amounts in values

by double clicking on a cell under values details of amounts are shown in a new worksheet

my doubt is
what should i do so that all the individual names are opened in different worksheets instead of double clicking on every cell individually

regards

Bala

I don't know if this is the right answer to youre quetsion.
But if you put names in the report filter of youre pivottable it will work

Then go to options, pivottable and then options and choose show reportfilterpages.
excel generates a pivottable for each individual name.

Patric