Create multiple workbook copies from one workbook and change data within every

Hi Guys,

I have one big workbook and i want this workbook to be copied several times based on my input data (but without changing main workbook - it is only pattern).

What is the best code to do this?

I thought about doing:
1. Save main workbook as copy
2. Open this new workbook and change data based on main workbook.
3. Close the new created workbook and create new copy of main workbook.

I have to have open all time my main workbook and copy of it in the same time,
but i think saving copy of main workbook and opening it every time will be not efficient.

please help,
Jacek

JLGWhiz thank you,

but still i have to open new saved workbook...

It is another way?

Jacek

thank you,

i think that it is not what i want exactly. Still you have to opening workbook.

Thank you!
Best Wishes,
Jacek