Hi Michelle
I'm not to sure if this is what you want, you can rename then by double
clicking on the tab but you will have to sort them by hand if need to change
the order.
Regards
Cimjet

You could run a macro:

Chip Pearson's:
http://www.cpearson.com/excel/sortws.htm

David McRitchie's:
http://www.mvps.org/dmcritchie/excel/buildtoc.htm#sortallsheets

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm