Forumla for creating yearly event calendar

Hi all,

I'm having a major problem joining data from one spreadsheet, containing dates and event names to another spreadsheet containing a manually inputed year long calendar.

At the moment dates are inputed into the calendar manually. I'm after a solution where by the dates and event names (in one spreadsheet) will automatically populate the calendar (in the format attached) when entered.

If this is possible, can you also add a feature which alows me to click on a box to either show the evnt in the calendar or not (to help seperate the events if i only want to look at one particular type).

I have attached the spreadsheets i have been working with and would appreciate any help you could give. I have exhausted all avenues and my hair is starting to get thin from this problem.

Cheers

Stew