Need a macro to Copy Cell in Sheet1 to the next empty cell in Column A, Sheet2

Need a macro that copies cell AF6 in Sheet1
Then pastes it into the next empty cell in Column A, in sheet 2

Or if there is another way of doing this, please post. I am a newbie at this Excel stuff

Here is the file: Bingo.xlsm
Thanks