I use Excel 2000 and have a workbook with 100 or so sheets. Since
navigating these sheets is cumbersome, I am looking at a way to
automate the hiding and showing of a group of sheets. What I would
like to see Microsoft do is provide functionality to collapse and
expand a group of sheets, but until that happens, perhaps a macro is
the best way to accomplish the task.

I have 10-30 sheets of individuals in the same region and each sheet
begins with the region abbreviation and then last name, first intial
(NE--Wilson, A.; SE--Davis, D.; etc.). Since I have little VBA
experience, I do not know how to create a macro that will select all
sheets that start with...

Also, if anyone has suggestions of other ways they manage navigation
in large workbooks, please advise.

Thanks,
Brent