VBA - Getting row of macro button and copying data from that row

[Quepid123]

Test.jpg

What I require
• Identify the row the macro button is in, copy the 7 cells of data to the left of it in that row (data only ie not colour of cell etc) (from column B to column I)
• Paste row into next available row in separate worksheet
There are thousands of rows of data so I require a macro that all buttons are assigned to. I also need to know whether I will need Active X control or Form buttons.
The end product is that everytime a button is clicked that row is copied and pasted into the next available row in a separate worksheet.

What I have tried
By visual basic experience is limited to say the least. I normally record macros and edit them where required and this particular coding is well above my level of expertise.

I have searched the web and found that the following will be part of the coding for locating the row the button is in.*
*ActiveSheet.Shapes(Application.Caller).Name*
I have also found that the following will be part of the coding for pasting the information into the next available row.
*

Private Sub CommandButton1_Click()
    Dim Lastrow As Long
    Lastrow = Sheets("Sheet2").Cells(Cells.Rows.Count, "A").End(xlUp).Row
    If Lastrow < 4 Then
    ActiveSheet.Range("A10:Z10").Copy Sheets("Sheet2").Cells(4, 1)
    Else
    ActiveSheet.Range("A10:Z10").Copy Sheets("Sheet2").Cells(Lastrow + 1, 1)
    End If
    End Sub

*
Any suggestions for anything I could look into etc would be greatly appreciated.
Many thanks.