I am a real novice to excel so hope someone can help me to solve my problem.
I have a sheet that needs to be completed to calculate a score then that score needs to be transferred to a master score sheet that can be ranke into position order. How do I do this please?

I have attached a format with explanations of what I am trying to do to assist.

Score Program.xlsx

Thanks

Adrian