Excel Macro form help

Hi,
I have created a form in which I want to put a macro wherein whenever I click on the submit button, the areas filled up in the form are copied and pasted in transpose on a new sheet. However, it keeps getting submitted in the same row. I want it submitted in a new row each time. Please help.