Dave,

This is an excellent solution! I'm playing with it right now. My only
complaint so far is I'm trying to figure out how to have newly created sheet
moved to be the last sheet.

With the sheet.copy function, you have to specify a sheet for it to be
inserted before or after. If you tell it to insert after Sheet3 (let's say
that this is the last sheet in the book), it will always insert after Sheet3.
So you insert one sheet new sheet and it inserts after Sheet3. You insert
another sheet and it inserts after Sheet3 again, but before the one the
previously inserted. Did that make sense?

"Dave Peterson" wrote:

Have you thought of including a worksheet (hidden) in that workbook and
providing a macro that would create a new (visible) worksheet based on that
hidden sheet?