Pulling data from one tab to another based on a "filter"

I hope I can adequately explain what I need to do here, and if not, I do apologize. Please feel free to ask clarifying questions. I'm thinking this can be done in Excel but it's just that I don't know what function to use.

I have a large set of survey data from a series of classes that employees took at my company. It's basically pre-course and post-course survey responses to 23 questions along with demographic data for each respondent. I would like to have one tab that has a series of tables that show the pre and post averages for each of the questions but that automatically pulls the data from another tab on the worksheet based on an item on which I'd like to filter.

For example, I'd like one table that shows the average survey responses for all of our Major Markets employees and another for our Growth Market employees. There is a column in the data that designates which employee type each response belongs to.

I know I can use autofilter on the data tab and filter out what I want, but I have to do that each time I change the parameter on which I want to filter. Is it possible to write the code for the data table to say, "sort through all of the responses but only give me averages for this question when column F has "GMU" (or MM, etc.) in it?

I'm attaching the sheet below that I've been working on. The fist tab, Pre+Post Only has the source data. The second tab is where I'd like to have the tables that would pull from this data. The data is refreshed at least quarterly, so I want to have the ability to drop in the new data without having to redo formulas (which is what the person who handled this before me had to do).

The second tab, Table, shows the type of table I want to create. I easily can do the "all" data table as it just pulls the averages from the top cells of the other tab. The data from the other tab is what populates the cells from E4:AI6. On top of creating the "All" view, I'd like to be able to have a formula that says, "look at that data and give me just the responses as if I'd filtered by GMU in column F." We'd also like to be able to do a similar command to populate tables for other views (like business units or such).

So is this at all possible? I'm figuring it is, but I just can't wrap my head around how to do it without having to manually filter the data first, and I'd rather not have to do that.

Thanks in advance for your help.

Bump -- Just wondering if anyone had any ideas. Thanks!