copy/move sheets and then repeat inserting next sheet below first

Good Morning All. I am way out of my depth with this process and can use all the help I can get. I have a monthly employee worksheet "Monthly Data" that I need to generate
payslips for, the employee worksheet is filled in by a userform along with all monthly information. This is where I get stuck, I want to create a payslip for each employee
from "Monthly Data", I have a worksheet "Payslips" that has the layout I want to use for each employee. My question is how do I get vba to insert the first employee name
from "Monthly Data" to "Payslips" copy/move the payslip to a new sheet and then repeat for any other names in the list below the first? Any guidance will be most helpful.

Uploaded the file but it doesn't appear in the attachment window to attach to the post

The file is attached and what i want to do is in a comment box on sheet "Monthly Data"

Thank You alansidman. Now I just have to get all the named tabs into one sheet