Excel Auto Calculate and Save to new row

Hi,

I am using several random number generators which change output. Each time I recalculate it changes all of the data in row 10. I want to quickly be able to run 1000 iterations of my analysis and save the data each time, so I can look at all of the data in aggregate.

So effectively, I want to copy the data in row 10 to a a new row, but each time it runs, it should put the data in the next row.

So first, it copies to row 13, then row 14, then row 15, etc.

Does anyone have an easy way to do this? Please let me know and thank you

Michael