Use list to input employee ID to template, copy it, and repeat next down in list

Hello good people,

I am building a basic dashboard, I have created a master template which I would like to first make copy of the template, input an employee ID in a certain cell and repeat for the next employee.

Steps required:
1. Make copy of Employee 2 worksheet ---(this is the master template).
2. Grab first employee ID, located in A4 of the List worksheet.
3. Repeat until end of list is completed.


I have over 200 of these templates that I need to create so just looking for a way to eliminate calluses on my finger tips

I have attached a file for reference.
Thank you kindly.