Help! I know so little about excel that I can't even explain what I need!

if the linked sheet I did 2 things:
a) the TOTAL formula for each candidate I changed to:
=SUM(K7:AJ7,AR7:BC7)
because columns AK - AQ are all summed up in AR so i skip them so you don't 'double add' them
b) I reformatted the sheets so COLUMN A is the list count (1,2,3,4,...) and column 2 is the date to make the sorting/formula easier assuming you want the count 1,2,3,4 to still be that way on the master. If on the other hand you want the list 1,2,3,... from the CANDIDATE sheet to stay with the candidate so the MASTER sheet is NOT in order but rather refers to the corresponding number on the other sheet, we can shift the SORT formula to column A
c) I added a basic SORT formula onto the MASTER and reference the entire table from the CANDIDATE sheet and sort by the last (TOTAL) column highest to lowest.
d) I added an IF() statement just to blank out the 0 values to make it look cleaner.