Want to auto populate a row from one sheet to another when a form button is pressed

[Vaticus]

Hello,

(excel 2007)
I am looking to use a button to auto populate a range of cells from the respective row to the bottom of a table on another sheet and then delete that row on the original sheet. For example, on sheet two I have a button in cell J2. When I click it, I want it to auto populate A2-I2 to the last row of my table on sheet 3 and delete A2-J2 from sheet 2. I tried recording a simple copy and paste macro using relative reference, but it doesn't seem to work. Also not sure if an active x or form button is the best to use in this scenario. The purpose of this workbook is tracking the progress of people through a submittal system. So sheet 1 is people pending submittal, sheet 2 is people pending qualification, and sheet 3 is to track those who have been qualified for 2 years. Is this possible?