Auto sorting in excel

I am having a bit of trouble with auto sorting in a documanet I have drawn up to display team statistics. There are two sheets, the 'input sheet' which is protected and all cells locked besides where the responsible person will input scores as they become available. Most of the calculations are done on this sheet. This information is then pulled through to the 'team scores' or display sheet where some other minor calculations are done. The 'team scores' sheet is for display & printing purposes only and once protected, nothing is selectable on this sheet.
I would like to have this sheet auto sort based on the calculations done in the 'team ranking' or k column when data is entered in the 'input sheet'. I know this is possible but I do not have much knowledge of how to do this. I have tried recording a macro but this does not work once the sheet is protected and also, as I am not the person using the workbook, I would like this done automatically when the user enters the data.
I have attached a copy of the workbook and I have also removed all protection in case the person kind enough to help wants to see the formulas and where they are linked. I have also shown data outside the tables but this should normaly be hidden in the completed document.
Also, this workbook will be used on Excel 2000 the most as this is what we have at work where this document is exchanged.
Any help would be greatly appreciated!!!!

Regarding my above post, I have two sheets, one input sheet that does all the calculations and one display sheet that merely pulls through and displays the data from the input sheet. Is there any way to create a button to autosort the display sheet based on certain criteria as data is updated on the input sheet? My input sheets are also protected (with certain cells unlocked) to prevent people from tampering with the formulas, this wouldn't create a problem with the autosorting button?