If you Pivot table is summarized by VP, you should be able to double
click on a value related to one of the VPs and Excel will create a
drill down sheet for that VP. Is that what you are talking about?

- John