For a pivot report, with the pages setup to each year, how can I
customize show pages command to append additional new pivot reports to
the current worksheet instead of creating new ones?

Additionally is there anyway to lay out each report on a different
page when doing this? This would save me time from having to insert
page breaks.

thanks