Sorting a Worksheet

[Bishop]

I have a spreadsheet with all the sales transactions for 10 different reps.
Each rep has between 50 and 150 transactions each. I want to sort the sheet
so that each reps 5 highest transactions are at the top. So rows 1-5 has
Bill's 5 highest transactions, rows 6-10 has Sally's 5 highest transactions,
rows 11-15 has Tom's 5 highest transactions, etc. How can I do this?

 

[Bishop]

Originally the data is arranged by rep. For example, first I copy 50
transactions for Bill and paste them to the spreadsheet then I copy 75
transactions for Sarah and paste them in the spreadsheet under Bill's
transactions. So on and so forth. The transactions for each rep are in no
particular order.