Hi Gizelle,

You cannot have tabs within tabs ...
But all your consolidation process can be done without this feature ...
For example your weekly data can rest in a different workbook, since
links between workbooks can perform your updates ...

HTH
Carim

Instead of using two worksheets, just put your data on a single worksheet.  You
can add a column that represents the week.

Then by applying data|Filter|autofilter, you'll be able to see any week you
want.

And by keeping the data in one location, you'll find that you can do many more
things with it--including pivottables, charts.  And you won't have to worry
about the data getting out of sync.

Hi Gizelle

What does your data look like?
Can you give some examples of the layout and what you are trying to
summarise.
It may well be that you could achieve what you want without resorting to
12 monthly tabs and 53 weekly tabs.

There is no problem with having this number of tabs within a workbook
though, and I find it far easier when carrying out further data
manipulation to have all data in the same workbook.
There is, however, nothing preventing you from using multiple workbooks
to hold the data.