Beating my own drum, but the technique for creating n sheets in a new file without looping is shown in RFC Tutorial - Deleting Excel Rows, Columns and Sheets. Just don't leave the user with a mess to clear up, but the technique for that is shown too, as is the explanation of what creates a mess.

Regards,

John Davies