How do I create subworksheets within a worksheet?

[Jill DeLong]

I have 5 main categories (worksheets) in one workbook. Within each main
category, I have sub categories that I would like to organize in seperate
worksheets. Ideally, I'd like only the 5 main worksheets to show and when
one is clicked on, the subworksheets appear. Is this possible?

 

[CLR]

Working from sheet set up as a "MainMenu", you could hide and unhide the
sheets so that only the ones relative to your interest appear. This would
require VBA. If you are still interested post back and someone will help

Vaya con Dios,
Chuck, CABGx3

 

[Mc/]

Your request is where I make use of the Outline or Grouping feature.
This will place a +/- icon to the left of the rows or columns, where you can
click on the + to expand the view to see the contents or click on the - to
collapse the view and hide the contents.