A pretty basic excel macro question

Hello,

I need some helping creating a macro that will copy a column of data from one sheet and transpose it onto a row in another sheet. Thats the easy part. The thing that I cant figure out how to do is to make a macro so that every time I run it, it will put the data on a new row in sheet2. Thank you in advance for any help I can get with this.

Yosef