Automatically transfer data from one worksheet to another

Hello,

I have an Excel workbook with two worksheets in it. The first worksheet is rows of data organized by Region, Client, Date, Product, Rep, etc. that is updated every week with new data. The second worksheet is filled with different =SUMIF formulas extracting specific data from the first worksheet automatically. I am stuck trying to figure out a way to automatically list our top clients for each region onto the second worksheet, so I don't have to manually type in our clients by region each week.

=VLOOKUP does not seem to be the answer, I have a feeling it may be a macro with coding which I am unfamiliar with. If anyone could PLEASE help me, I'd greatly appreciate it. You'd be making my life much easier and have my bosses think I'm super smart.