Hi Bill,
For sort worksheets in text order see:
http://www.mvps.org/dmcritchie/excel...#sortallsheets

To find a specific sheet is a lot easier if the sheets have been sorted as above.
Right click on a sheet navigation arrow to the left of the sheetnames, choose
your sheet or choose "more sheets", There is a macro to help you get to
"more sheets" faster.
http://www.mvps.org/dmcritchie/excel...htm#MoreSheets

---
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

"mrbillmsn" wrote in message ...
I have a workbook with about 150 sheets and would like to alphabetize them.
How do I do this. Also is there a find function to find a specific sheet
without scrolling thru them? And when I set up 1 sheet with named lines and
columns how can I apply this to all the sheets at once instead of copy and
paste one at a time. Thanks for your imput, Bill I'm using office 2000