Clustering worksheets

[Rotata]

Help,

I have a workbook with four worksheets. These worksheets are NOT identical
AND three of them feed into the fourth. This is good for one month of data.
At the end of the year, I end up with twelve workbooks. Not so bad if you are
only dealing with one set. I have about a hundred of these sets to manage
each year.

I could put four worksheets for each month in one workbook. That would be 48
worksheets. So many tabs makes navigation a little unwieldy.

Is there any way to cluster (not group) the worksheets into 12 sets so that
one could touch on February and only see the four worksheets for February?

TIA!

 

[evoxfan]

A few options to think about:
1. I am a fan of consolidated data, so I would put all data for a particular
month into one workbook even if it means having 48 worksheets. Although,
there is many worksheets to to each month, you should now only have 12
workbooks.
2. Once I have just twelve workbooks or data at the end of the year, this
data should not change. So, I would look at creating a summary wkst page in
each workbook with a pivot table. Although you have 48 wkst's, 12 of these
have consolidated data which the other wkst's feed. So these 12 wkst's with
consolidated could feed your summary page. Or, you could take the data from
these 12 wkst's and put it on one worksheet then have your pivot table feed
from it. After I accomplished this on all 12 workbooks, I would probably
look at creating a summary worksheet of all twelve months with another pivot
table fed from the summary page of all 12 workbooks. Then you would have an
overall summary page and one for each month. You could even insert links on
your master summary page to automatically open each monthly workbook.
3. You could just record a macro performing the exact process of making each
workbook look like you want it and use this same macro for all the other
workbooks. You could record a macro opening each month and assign this macro
to a button and give the button the name of the month it opens. That way all
you have to do is press the button to open the month you want.

Not sure I answered your question or not, but perhaps these options will
help get you started.
Good Luck.