VBA - add new row and copy values from cells to other cells on the new row

Hi,

When clicking the "add employee" button I want to add a new row after last row. Any value in yellow cell should go to the other yellow cell and so on.
I've managed to make the VBA add a new row but struggling with the remaining part.

Any input to get me started would be appreciated.

Sample.png

Formula:

Sub Add_Employee()



    Dim LastRow As Long

    LastRow = Cells(Rows.Count, "B").End(xlUp).Row + 1

    Cells(LastRow, "B").Value = "New Row"







End Sub

Best,
Thomas