"Auto-create" 40 Different Versions of a Sheet

This is my dilema,

I have a report I built on excel that is populated with data from an access database. The report pulls monthly stats per "sales group" I made one cell into a validated list that once I change it to another sales group, the entire sheet is updated with the values of the new selected group....

I have 40 or so groups, If I wanted to quickly print or view all 40 reports, how do i do that?