Help with having data automatically sorted in highest to lowest order?

Hi,

Just wondering if anyone could help me with a sorting problem. Basically, I would like to take data from multiple sheets and have them transfer to one master sheet. On the master sheet this data would automatically be sorted from highest to lowest. I attached a very simplistic example of this. Ideally, I would like to scores for each student to transfer to their respective name and sort highest to lowest at the same time on the master list. Thanks!

-Dan