Every month, I update a workbook with 35 sheets that I have to break it won
for 17 people, the sheets that I send varies for everyone (1 to 17 sheets),
the process I use is: create a copy of the sheet(s) as a new workbook, what
I am looking for is to have the sheet(s) selected and run the macro to do
the work (I would do it with a button).
I tries to use the macro recorder, but unfortunately comes with the sheet
name.
Could somebody help me to get this task automated.

Thanks