After deleting and adding worksheets, I see in VBA, the MS Execl Objects are
ordered thus:

Sheet1(First sheet)
Sheet3(Second sheet)
Sheet6(Third Sheet)

How do I rebuild this file so that the sheets a

Sheet1(First sheet)
Sheet2(Second sheet)
Sheet3(Third Sheet)

The sheets have named lists and other references between sheets that must me
maintained. I tried the 'Move or Copy..' but that maintained the Sheet*
number. I tried to create a new workbook and cop the cells, but that lost all
the Named list references.

I'm doing this because I'm building a master template and want it 'clean'
and in order. And I'm trying to avoid redoing all the lists, etc.

Any other ideas?

Thanks,
John S.