load highest value from column to another

[dealer]

I have uploaded a w/book and hopfully someone will take a look.
I have sales people and there sales amounts organized by location.What would like to do is load the top 20 (or there abouts) sales people&amounts from each loaction.
ex north(Column A = 20 from columns F3 to J8). South (column B = 20 from F15 to J20) and so on.Thanking you.