Alphabetizing mulitiple worksheets in Excel 2003?

[Deena at DCH FD]

When using Excel 2003, is there a way to alphabetize mulitiple worksheets? I
work with 60+ in the same wookbook each month. I've searched MSHelp and
online but can't find the answer. Can someone help?

 

[Dave Peterson]

You can drag and drop manually...

or

You could use 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

 

[Deena at DCH FD]

Looks like I have some studying to do! I've never run a Macros before.
Thanks for your help!