Excel simulation help (Auto copy and paste)

I have a complex simulation that displays different values on cell A1 upon editing any cell. I want to create a histogram for these data but instead of manually copying and pasting hundreds of times, is there anything I can do to make excel copy and paste the value on cell A2,A3,A4....etc each time the spreadsheet is edited?

Thanks in advance!

PS: In case I wasn't clear, the picture below should explain everything:

https://s32.postimg.org/cme49w2xh/image.png

In the case above, I could simply drag the values to the right but I cannot do that in my original simulation since it is too complex.