Copy and paste values automatically to empty cells below

Hi - for background, I created a "slot Machine" in excel that combines three random number generators and generates either a -$1 or +$10 if you don't have 3 of the same numbers in a row (lose) or if you do have 3 numbers in a row (win).

I want to track the number of losses and wins (both the absolute amount (in theory I would like to roll thousands of times) and the rolls' specific values ($-1 or +$10)). How do I copy the win or loss value of any one "roll" and paste it to another sheet and then copy the next win or loss value and paste it in the cell below the prior win or loss value and so on (so i could track thousands of "rolls")?

I also want to sum these values so i need to create a sum calculation that automatically increases its range as the number of "rolls" increases.

Thanks in advance.