Macro for renaming sheets

Thank you all for your help in the past. My skill level is pretty low so I greatly appreciate it.
Here’s my situation that I need help on:
I have a sheet with 200 names on it organized into columns by last name, first name, category, etc. I need to provide a sheet for each name. Basically, a workbook with 200 sheets and the name of each sheet is equal to the last name.
Is there a macro that I can run that
(1) will first “take row 2 of Sheet1 and paste it to row 2 of sheet 2”
(2) then “it will change the name of ‘Sheet2’ to equal the person’s last name located in ‘A2’ of the same sheet (Sheet2)”
(3) and finally it will “repeat the process on Sheet3; copying row 3 of Sheet1 to row 2 of Sheet3 and then renaming Sheet3 to equal the person’s last name located in ‘A2’ of the same sheet (Sheet3).
It obviously does not have to be performed by only one macro. Any advice would be greatly appreciated.
-Joe

Got it.

Thank you again VBA Noob. I truly appreciate it!

-Joe