combining tabs through drop downs

[jmoerbe]

I'm not even sure if this is possible, or how
easy/difficult it would be, but if someone could at least
tell me where to look or what I need to start researching
to be able to do this it would be great.

Basically, I want to take a workbook that has 10 tabs -
each of the tabs has similar formatting, but different
info. What I want to do is combine it all onto a single
tab and use a drop down to select what info is viewable.
ie - rather than having tabs for june, july, and august,
those would be drop down choices.

Keeping in mind that the info for each is similar in
formatting, but not exactly the same - multiple tables and
subsequent drop down menus. And there are enough columns
and rows of info, that I think a pivot table would be too
unwieldy.

Can anyone point me to any info on how to do this?

Thanks!

 

[Guest]

That isn't exactly what I had in mind, but it certainly
does the trick! Thanks! And thanks for such clear (ie -
step by step) instructions!

~J