TOP 5 based on multiple criteria

I've seen several LARGE queries and have tried with little luck to take this formula to the next level.

Basically I have a few different Tabs, and I'm trying to get the TOP 5 Sales Reps based on each region.

For example

REP REGION REVENUE
Sam NORE $1,000,000
Tina NORE $2,000,000
Tommy SOUE $1,000,000
Brian SOUE $3,000,000
Chuck NORE $2,000,000

So I would expect a result of the below when NORE is my filter criteria.

Tina
Chuck
Sam

But, I can't find out how to modify the current formula I have which can take into account the regional data.

Here is what I have now, which works well to give me the TOP X Sales Reps overall.

=INDEX('Sales Data'!A:A,MATCH(LARGE('Sales Data'!G:G,ROW(A1)-ROW(A$1)+1),'Sales Data'!G:G,FALSE))

Other notes, Sales Rep will always be a unique value (no duplicates in the list)

I appreciate any assistance provided.

Ok, I know I'm making it more difficult, since a Pivot Table would get me the data, however...

Basically, I have 1 tab as my dashboard, and on that tab there is a dropdown with regions to be selected, the dashboard has a whole bunch of data that is spliced out to the specific region that is selected in the dropdown.

This data is dynamically provided by sifting through all the raw data that I have listed on other tabs. So, as Sales Reps make sales, the data is automatically summed up/calculated, and is transparent to the userbase (Sales Reps). I have had issues where they modify data, or break a pivot table, and I have to go back in because the did something. The dashboard and ALL tabs are locked and protected so that they can't touch it, and 1/2 of them won't bother to learn how, or even want to create a pivot table.

Is there anyway to get the same results without a Pivot Table? NO, is a completely acceptable answer.

Thanks, I'll give this a shot, never worked with AGGREGATE.