can you group multiple worksheets into a sub menu
 

Here is what I'm looking at doing. I have made 3 seperate workbooks with
probably 10 worksheets per workbook. Each worksheet is linked to the other
worksheets in a given workbook and these sheets often contain complex
calculation equations. I am trying to merge these 3 workbooks together into
one master workbook. Instead of having a Master with 30 worksheets I would
like to have a master with 3 subfolders that when you select a particular
subfolder the 10 worksheets specific for that subfolder are available to be
selected.

can you group multiple worksheets into a sub menu
 

Not possible in XL though that sounds like a useful feature.

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"ST Jude" wrote:

Here is what I'm looking at doing. I have made 3 seperate workbooks with
probably 10 worksheets per workbook. Each worksheet is linked to the other
worksheets in a given workbook and these sheets often contain complex
calculation equations. I am trying to merge these 3 workbooks together into
one master workbook. Instead of having a Master with 30 worksheets I would
like to have a master with 3 subfolders that when you select a particular
subfolder the 10 worksheets specific for that subfolder are available to be
selected.