Sorry for the duplicate post admin.
As am new so didn't know these rules.

You can close the thread.
That Column E is my actual requirement admin.
I used to enter the participant details in the sheet.
Once the button is clicked it should create sheets with the datas from the template sheet.
Please solve my problem.