if i have a client sheet like this:

No. First Name Last Name Phone # start Date End Date Client Sheet
#_001 Client 1 LName 1 416-123-4567 01-Oct-15 01-Nov-15 Button
#_002 Client 2 LName 2 416-123-4568 02-Oct-15 02-Nov-15 Button
#_003 Client 3 LName 3 416-123-4569 03-Oct-15 03-Nov-15 Button


i want to add a control button for each row under Client Sheet column to run a macro.
Macro creates a new sheet, names it (client 1) and writes "Client 1" in B1 and "LName 1" in B2.
now the macro works fine, but the question comes when i want to place the button on every single row.
i want each button when creating a new sheet should take the date from the row it is located.

I mean if i click the button or second row it should create a new sheet, name it (client 2) and write "Client 2" in B1 and "LName 2" in B2.

any help is appreciated.

thanks,