Sorting worksheet tabs into alphabetical order:

A list of worksheets in a worksheet may be useful, but it is
not necessary in order to sort the worksheets, and since that
worksheet is deleted anyway wouldn't seem practical.

see SortAllSheets macro in
http://www.mvps.org/dmcritchie/excel/buildtoc2.htm .
--
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm