I am trying to get information that is typed into a form in Sheet 1 to reflect in sheet 2 and then save it.

Sheet 1 looks like this
A B C D
1 Name: _____X_______ Surname: ___Y________
2 Adress: ____Z_______ EFR num: ___A________

Sheet 2 looks like this

A B C D
1 Name Surname Address ERF num
2 ___X____ __Y_____ _Z____ ___A_____
3 ________ _________ ________ _________

I can do this using a vlookup formula but if the information changes on sheet 1 then the information changes on sheet 2. I need the information on sheet 2 to remain there and to allow for adding new information using the same form on sheet 1. The new information on sheet 1 must then be added to line 3 on sheet 2