I have a spreadsheet that pulls information from about 5 other spreadsheets, and of course this happens automatically each time the spreadsheet is opened. My question is, is there a way to re-sort the list each time that information is pulled?

I am trying to make a top 10 list of my salespeople and I am looking for a way to have it re-sort the list automatically after pulling the updated information from the other spreadsheets.

Suggestions?

Thanks in advance