Hi Kate
I found this solution on the Web which appears to provide that functionality:@
ASAP Utilities

slypimpb | Fri, 27/08/2004 - 16:54 | Permalink
I would recommend a very excellent addin for Excel called ASAP Utilities. You can find it here:- http://www.asap-utilities.com/
It's a freeware add-on with a large library of useful functions not built into Excel. You'll probably never use most of them, but I've found some very useful. Installation is simple, and I would recommend anyone who uses Excel on a regular basis to install it and have a play around.
The function you are after is in the "Sheets" menu - "Sort all sheets in alphabetical order"

Good luck.
Tony (OTPM)