Auto sort scores

I am running a charity quiz where there will be 40 tables competing for prizes. There will be 10 rounds and 1 bonus round, there is a tab for each, where we can enter the scores they get for each round. The scores will be shown on a screen and therefore need to be laid out landscape (resulst sheet) as they are rather than on one long list.

As the scores are entered, I want the results sheet to re-sort itself by the team with the highest score at the top and the related team name listed next to it.

Can you help?