Moving & hiding worksheet groups

[Bern Notice]

Is there a way to:

We want to have a summary worksheet for each day (i.e. Monday, Tuesday,
etc.) and those are the only worksheets you see. But we want to have
multiple hidden worksheets "grouped" with each day so that when you click on
the worksheet for a day (e.g. Monday) then the worksheets "grouped" with the
Monday worksheet are listed after that tab. Then, when you click on
Tuesday's worksheet, the Monday "grouped" worksheets are hidden again and the
worksheets "grouped" with Tuesday's worksheet are shown after that tab.

Can this be done without a macro? I guess a macro can be written to
accomplish this.

Thanks,
Bernie J.

 

[DJH]

Try Custom Views, there you can hide worksheets, then add a Custom View.