title: how to transfer a row of data in other sheets by its collumn

[doms123]

I'm using excel2007 I have 2 Sheets one is the input data sheet
the other is the masterlist in the first sheet it goes like this

(column1) (column2)
(row1) Name ________
(row2) Address ________
(row3) Telephone No. ________

then a button that has a caption like save or encode
in the second sheet i have the master list that goes like this

(column1) (column2) (column3)
(row1) Name Address Telephone No.
(row2) Applicant 1 Texas 123456
(row3) Applicant 2 New York 456789
(row4) Applicant 3 Canada 789456
(row5) Applicant 4 Hawaii 321654

then a button that has a caption like edit or transfer
if i click the (row3) or select the rows and click the button
then the datas will be transfer in the first sheet
then it goes like this

(column1) (column2)
(row1) Name Applicant 2
(row2) Address New York
(row3) Telephone No. 456789

then in the second sheet the whole row will automatically be
deleted and goes like this

(column1) (column2) (column3)
(row1) Name Address Telephone No.
(row2) Applicant 1 Texas 123456
(row3) Applicant 3 Canada 789456
(row4) Applicant 4 Hawaii 321654

then if i click my save or encode button in the first sheet
it will go this way
(column1) (column2) (column3)
(row1) Name Address Telephone No.
(row2) Applicant 1 Texas 1 123456
(row3) Applicant 3 Canada 789456
(row4) Applicant 4 Hawaii 321654
(row5) Applicant 2 New York 456789

PS. i just need a code or syntax in the button on the
second sheet or the edit button
Please help me....
Thank You in advance