pointers on a vba code that works like a "mail merge" to keep it all in excel

Hi, I am a new excel user and I am having troubles making a macro to take the information from a master client list sheet and copy it to their individual client work sheets from a template sheet. I need something that will automatically copy my template sheet and then take the respective cells from my master list sheet and copy it to the specific cells on the newly copied template, then copy a new template sheet and proceed to the next row/client. It's like a mail merge, but I need it all to happen in excel.

I have made a fake workbook to show exactly what I am working with...just on a way bigger scale.

P.S. If there is a way to automatically name the newly copied template as the corresponding client name that would be great too...maybe I'm asking too much.

Hello,

Please look at the code below and see if it helps.

Please Login or Register  to view this content.

Thanks always run the sub "CreateSheets_WithNames"

Try

Alter column reference to suite if it is needed.

Please Login or Register  to view this content.

Wow, that works great, thanks so much!