Populating a calendar from a spreadsheet

Hi There

I am a complete excel novice and what I'm after is way beyond my capabilities so hoping someone can help me!!

I have a spreasheet with x2 tabs, one displaying a full year calendar and one containing a spreadsheet. I am trying to cross reference the info from the spreadsheet to populate the calendar. I've attached the spreadsheet i'm working from but what i would like is For the calendar to populate with the dates the show is running (columns D-E) state the name of the show (column A) and its location (column c) , also to state the size of the stand (column I). Then if it can be colour coded ie green for confirmed and yellow for tbc (column O)?

Many thanks, any help welcomed but i don't even know where to start in excel help (think i might book myself onto an excel course!!)