I'm not sure where to put those.

I think it would be better if it the cell AF6 in Sheet1 could be copied and then pasted in the 1st empty cell in column A in Sheet2
Is that even possible?
I've seen some amazing things in excel and this should be cake :P