More fishing excel help needed please guys

so i have this workbook that added up the league points
I put new members on to interim and they get added to the match day sheets
when I put the results in I see on the interim they have weights and points but on the summary, the names stop being added at row 40 , but I may have up to 250 members
where have i gone wrong

thanks for any help in advance..