Macro creation help required.

HELLO frnds,

i have attached a file and i want to create a macro for this file even i have recorded macro but i'm not success in what i want to do.

There is 3 sheets and sheet1 have data which we need to transfer to another sheet, sheet2 as in excel file by macro if i click on submit data from sheet1 would transfer to sheet2 and if i click 2nd time on submit button then the data should transfer to sheet2 in 3rd row and if i again click on submit button after feeding data in cells then the data should transfer to sheet2 in 4th row..

for more details check file.

Thanks,

Vishnu