inserting rows with 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

Hello friend,

This does what you want i think

Option Explicit

Sub Macro1()
Dim blastrow As Long
Dim clastrow As Long

blastrow = Sheets("Sheet1").Range("B" & Rows.Count).End(xlUp).Row + 1
clastrow = Sheets("Sheet1").Range("C" & Rows.Count).End(xlUp).Row + 1

With Sheets("Sheet1").Range("D6")
    .Copy Destination:=Sheets("Sheet1").Range("B" & blastrow)
    .Copy Destination:=Sheets("Sheet2").Range("E1")
    .ClearContents
End With
With Sheets("Sheet1").Range("E6")
    .Copy Destination:=Sheets("Sheet1").Range("C" & blastrow)
    .Copy Destination:=Sheets("Sheet2").Range("E2")
    .ClearContents
End With
End Sub

Note: I changed the data entry cells from B6 & C6 to D6 & E6. The reason is because you would write over what you put in. You can modify those ranges to somthing else but you shouldnt have it in the same column that you are populating. Also on sheet 2 you have an array set up. The macro will not transpose in an array i dont think. You could just use a lookup function in E1 and E2 to accomplish what you want i think. Let me know.

Thanks stnkynts.

Code works perfect for the given conditions you mentioned above.

I'll try and modify my spreadsheet to work around the code.