I'm not sure Leith knows what sheet number it is using.
That is if you have nr1, nr2 and no 3 or 4 but nr5 next he might not put the result on sumar on the correct number column.

Test my code to see if it is what you want.