The trick is to add an empty sheet before all the others and call it something like Start ( or whatever) and another called Stop ( or whatever) as last of the data sheets ( before "running Total).

Whenever there is a new data sheet be sure to insert it between those two .
I have changed the formulas in the Running Total sheet ( yellow highlight) taking this into account.Those sheets must remain empty.
I leave it up to you to change the rest.
A couple of tips :
DO NOT use merged cells, they are nothing but trouble. Use " Center across selection" instead
You do not need to reference something like E13:E13. E13 on its own is sufficient

Attached Files

Word Scoring 2024 Season(1).xlsx (107.7 KB, 3 views)

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post