I'd start by looking at Debra Dalgleish's site:
http://contextures.com/xlPivot09.html

PFLY wrote:

Hi,

I have a pivot table the has a page for a list of 30 objects. Can someone
help me with a code that will select the first object from the pivot page,
print, and then repeat till all of the objects have been printed?

--

Dave Peterson