save custom auto sort for multiple table

I have 7 tables on two different sheets that have the same headers. I want to be able to save a custom sort or even have it auto sort each time i update the data in the tables. Please help.

could you send a sample?

Another approach would be to RECORD in a macro the sorting for each of the 7 tables.

use VIEW->Macro->Record Macro to start recording. When you are done press the little square on the bottom left-hand side corner.

This of course, assumes that the tables are fixed in size.

Cheers,

To be a little more detailed, they are tables for sports standings by cluster. The tables are the same except for school names. I want them to auto sort by most wins, least losses, etc.

Then could you include a sample (non-sentive data)

Here is a copy of the workbook.