summary sheet

I am not sure if this is possible. I have 6 different market segments so I have 6 different summary sheets. But I have 12 different VP's who have to approve or decline the tradeshow. The summary sheet is filtering by market segment but can have different VP's. So in the summary sheet I want it to have a section for each: 1. approved 2.pending 3. declined. But I don't want it to have 12 columns for each and every VP. Is this possible?

Answers