Agenda with entry field

Hi,
I'm new to this forum but I'm a huge fan of excel!
I'm trying to make a 1 year agenda that can be filtered by column on subject with a data entry field that allows people to enter daily events. Some of those events may be on the same day at the same our. The "data sheet" will have the fields that I attached on the excel document.
Here's the "catch", on the data sheet, or some other sheet, the agenda must have have a "look" like a "regular agenda", with all the days of the month and with the events that are marked for that day, even if on the same hour.
I'm a bit lost on how to start so any help would be appreciated.

Thanks a lot in advance.
Best regards,
n4rs

Agenda example.xlsx

Quick info:
I'm using Excel 2010 on a x64 windows 7 based OS.