Hi Ronnie

There's more than likely better ways to do this but I think this will work for you. Try it out and see.

I've hidden the Blank sheet, it acts as a template, so you don't want it to get renamed and used. Alt + F8 will give you access to a macro which will add 10 blank sheets at a time. This macro can be run at any time and will always add another 10 blanks.

Let me know how it goes.

Attached Files

5-12-15 Sample_2.xlsm (148.2 KB, 11 views)