Consulting a table and changing the content and place the new content back in the table

Hi, I want to use a macro to do the following. I have a table with data (info about different, a lot of persons...). The first column is a unique number (called 'number') referring to the person. Now I want to use a macro to consult the table by using the 'number'. On a second page I fill in the 'number' and I want that a macro consults the table and gives al the information of the corresponding person on the second page. On this second page I want to do some changes on the information of the person and then I want to put back the corrected information in the table.
What I don't know is how to find the correct row with the information of the person with a certain 'number', both for consulting and re-writing the changed values. I could do it with (advanced search, but I find this not a clean solution) I tried also with 'advanced filter' but this also did not work properly. (relative reference...)
Anybody experience with this.
Thanks a lot.
I'm an amateur in recording macro's and no experience with VBA and forms.

Hi Richard,
Thanks for the reaction.
I put a simple example attached.
What I don't know to create is how to search an existing article and put it in the input-page, change where necessary and put back in the file 'orders'
I put a macro to create an new unique article-number and also a macro to put the input in the orders.
Now I want to search on article-number all the info of the article and put it in the standard-file 'input', change eventually the info and put back in the file.
I hope I can do this with the 'recording macro'- option because I have no experience with VBA-code or forms.
Thanks a lot for helping me.