Show the SUM of a list of numbers onto another sheet

[twisted31]

I need to show the sum from a list of numbers i get everyday onto another sheet. the only problem is I get a different amount of numbers each day.

For example, one day i might get

1
1
1
2

Then the next day i might only get

5
3

I cant color code it because the number of lines will change depending on how many numbers i get, so i'll have to delete/insert lines, which also means i cant make it show the SUM of all those numbers on a seperate sheet by using every nth cell because it will always be different.

How could i make it so that on another sheet, it shows the sum of however many numbers i get that day, even if its always different?


One thing i've noticed is, if on the seperate sheet, if i do =D10 (or whatever cell has the SUM), then insert/delete a line, D10 will change to D9/D10 or whatever the correct cell is, except i dont want to have to =D10, =D18, =D26 , and so on, because that will take a long time. Maybe theres a way to Do the =D10 thing all the way down?