Add and Modify rows in a Excel Table from another sheet

[asokaw]

I have a excel table with Emp No, Name Salary... in ( Sheet 1 ) organized horizontally
I need to enter data to that table from another sheet ( Sheet 2 ) where the same fields are organized vertically.

After adding the data by press of a button the Sheet 1 should get updated with the new record
Also if I need to modify the record in Sheet 1. I need to enter the Emp No and press a Button so it will populate with the existing data & I can modify
Sheet 1 should be protected

Please note I cannot use Excel Forms as the number of fields are more

Thanks & Regards