Macros: Insert Rows/Submit Button

I'm completely new in macros so please bear with me.
How would i modify a macro so it perform the following in the attached spreadsheet:

If i enter data in cells B6 and C6 and click on the submit button, the data will appear in cells B4 and C4 respectively and the data enter area is cleared for next entry. If i enter a new set of data and submit again, it will appears in the following row, i.e B5 and C5, and so on.

In addition, when hitting the submit botton i would like the new data to show in E1 and E2 in sheet 2 (transposed). And following columns for following entries.

Hope this is make sense.
Thanks

Duplicate post, thread closed. Please take a few minutes to read the forum rules before posting again.

Thanks.