Table sorting and Position recording using formula

Hi,

I've been developing spreadsheet for a Prediction League I run over the past year or so, this forum has been a very useful source so far and there was one more thing i was hoping it could help with?

I'm looking to have my league table update when players scores change. At present each weeks scores are linked from individual sheets into the 'Scoresheet' sheet, in the workbook attached I've removed these links for weeks 1-5 so you can see how the rest of the sheet works. What I'd like to achieve is, when these scores update, my league table is sorted to reflect these changes. Players new positions would then be recorded in 'ProPositions'.

I've seen some examples of auto sorting tables using combinations of 'dummy' tables and vlookup formulae but I cannot get my head around how they work. Not sure this is definitely possible for my own situation. I'd very much appreciate any help possible.

Thanks & Regards
Shaun