I have been trying to create a filing system for a lawfirm that I am currently interning at how I am struggling to create a way to copy the cell contents of a given cell and have it moved and "saved" so that when the original cell is changed the new one stays the same:

Here is what it should look like:

LastName: Duncan
FirstName: Charles
Telephone #: (910)-978-9886
Email:



Duncan Charles (910)-978-9886

(And when that dated is deleted it saves and when new data is entered it will go one row down).