Place result of random number generation in a list

I have a cell that generates a random number between 1 and 8 and when i press F9 it successfully updates this number. I want to place that number in a separate list, such that every time i generate a new random number, it gets added to the bottom of the list.

There isn't a formula that can do this. The two ways you can do it is using a Macro or just simply copy the cell and then click paste special and then values.