selecting pivot table items

hello,
I have a simple pivot table, based upon a datawarehouse, in which I have 2 report filters, the customer and the customer group.
When selecting a customer or a customer group, a bunch of calculations are made in the worksheet for calculating the customer profitability.
I would now like to have a list per customer with all the relevant profitability data. however, we have about 5 000 customers, so I would take me forever to select the first customer, copy the relevant data to a worksheet, selecting the second customer, copy the relevant data to a worksheet, selecting the third customer, etc...
so I would like to make a macro which would do something like this

for i
select pivot table item i
copy range a1, b5 , c8, d4 to worksheet X row i
next

I have no idea how to write the vba for selecting the pivot table items. Can anyone help me?

thanks, steven

no one? I kind of need this quite quick...

I came across these pages to when searching the internet, but I don't see how these URL's can help me?

hi,
almost there! See file attached
one thing though which doesn't work yet, is the copy function.
I have upload a sample file, coloured the fields yellow. I can loop through the pivot table, but the calculated result isn't stored and copied.
again, someone can help?