Copy Worksheet range (several) on a new workbook

Hi everyone,

I've have the following code to generate seperated pdf file (that's required) BUT now I need to create a new workbook which will have a copy of each generated worksheet (each with their name).

Please Login or Register  to view this content.

Note:
- Template1 is the master template where the macro will be activated (ex. button). Range to be copied to the new workbook and each new worksheet will be A1:I47.
- Data1 is the tab which have every new worksheet names and the associated content.

Any suggestion is welcome.

Attn PCI, the following code will provide a new workbook with all worksheets renamed BUT content from my template (infos from data1) isn't paste.

Please Login or Register  to view this content.

Solved by myself.

Thanks anyway!

@Alternsti
Could you be so kind and post your solved code please.
For people looking to solve the same problem or similar problem it is very frustrating to see that someone else had the same problem and that it was solved but no solution showing.
Thank you for your understanding.

Here's my solution

Please Login or Register  to view this content.

Thank you very much Alternsti, very kind of you.
Good luck