Viewing multiple worksheets on one main worksheet

Hi guys,

I'm currently creating a calendar of events for our training centre. We have multiple training course running on each day.

What I really need is one main worksheet with 2 drop down lists, one that will specify the area of training, the next the month. This would then display on the main worksheet the month calendar that the person is interested in.

Really it’s just a case of being able to view other worksheets on one main worksheet using a filter with 2 conditions. The calendars will already be set up on other work sheets so I'll have 5 May calendars each with a different area of training, 5 June, 5 July and so on. I just need the ability to filter a selection of those and view those worksheets on one main worksheet(So June's Adult Protection training for example, I'll only need to see one month at a time)

Hope someone can help I'm stumped

Ok I've attached the file. Its still in progress but should give you the idea.

As you can see, its the first worksheet that I want to display the other worksheets on. The other worksheets are the ones I want to display on the first page so there are calendars for Childrens training from May 09 till April 10 and then I've just started adding the C4U ones in after that, over all there will prob be 6 or 7 different areas of training all running from May 09 till April 10 which will be added in later.