Pivot Table help
 

Please I need help with Pivot table. I have a Pivot Table that Have multiple
Rows of data but each row is collapsed and there are multiple rows of data
under each row.

I want to run a macro that will pick Each Row and their corresponding
collapsed data to another sheets.

Pivot table Example in Sheet 1: When collapsed
Cell A B C
1 + Hour Today's Date Only Hour
2 +Time Today's Time Only Time
3 +Day Hourly Day Monthly Time

When Expanded in sheet 1:
Cell A B C
1 -Hour Today's Date Only Hour
10/14/0994 12.00pm
01/10/9001 2.00pm
2 -Time Today's Time Only Time
07/11/2005 3.00pm
11/10/2000 8.00pm
3 -Day Hourly Day Monthly Time
------- 2.00pm
8/10/2009 13pm of day

Final Output
Sheet 2
Hour Today's Date Only Hour
10/14/0994 12.00pm
01/10/9001 2.00pm

Sheet 3
Time Today's Time Only Time
07/11/2005 3.00pm
11/10/2000 8.00pm

Sheet 4
Day Hourly Day Monthly Time
------- 2.00pm
8/10/2009 13pm of day