Maintain data on one sheet and sort on another

Hi, I am the scoring with a club

I have a problem I am trying to get my head around for a competition. Sheet 1 is is the INPUT screen where results for eight competitors are recorded in competitor order and totalled. Sheet 2 is the RANKING screen where the results recorded need to be sorted by score to show current rank....I can do it manually but would like to automate the process.

Regards
Bill