Here is my goal - to have a form that users will use to input various data such as name, email, phone, address, profession, interests, etc. I would also like the users to be able to update this information using the same forms, but not have to input every single data item again as that can be time consuming.

My issues at the moment is efficient data retrieval for the latest information etc. I am currently using similar formula as seen below for multiple columns of data: 

Please Login or Register  to view this content.
First and Last names are the base criteria that I use, but perhaps it would be good to assign a number to each individual. Thoughts on that?

My end goal is to have a sheet that contains only the most current inputs from each user:

example final sheet.JPG

- So I suppose, to simplify what I stated above, I'm looking for equations to better retrieve and capture current data based on multiple criteria - name or id number, date. It may be easier at this point to manually input update information. Another thought was perhaps using a free online database, but I haven't done much research on that.