I sort of see what you're trying to do. I think a more efficient way would
be to just go to the data that is the source of the pivottable and "run
through" it with a macro, picking up all the data that matches your criteria
and then go to your destination file and write all that information out in
the order that you wish.

I could create a simplistic example if it would help you?