HOW TO ADD OR DELETE ROW AUTOMATICALLY
 

I want all data which I type in one column in worksheet 1 to appear in the
worksheet 2. I can use Excel formula in the sheet 2 and to lock the second
sheet
in order formula can not be deleted by user. But I need the user to write
some comments in the bottom of the same column of the Sheet 2, therefore some
cells should be left unlocked. The number of rows which will be edited in the
Sheet 1 (and to be automatically appearing in the Sheet 2) is unknown.
1. How it can be done that text in Sheet 2 which comes from the Sheet 1 is
protected, but all other cells can be used?
2. How to make that new next row with same format to be added in the table
if I start typing in the first row? When after first row I start typing the
new row, the third row is added. Ando so on. But if data in the row deleted,
the new row will be automatically deleted as well.