Interactive Calendar for managing deadlines

Hi all

I am trying to create an interactive calendar on Microsoft excel as a way to help manage and monitor up and coming reporting deadlines at work.

Visually, I would like a calendar on one sheet that shows a month . I would also like to be able to select the month and year using a drop down box . I imagine I will have a separate sheet that lists the name of reports and the date they need to be completed by, this should then feed on to my calendar so I can see the information on any date .

It would be even better, if I could click on a date on the calendar for it to open up a new sheet with a table that shows the information across three columns : the name of the report and date report completed and who it has been submitted to.

I am very new to VBA so any detailed help that can help me build this from scratch would be very much appreciated.

Please see attached for my idea.

Thanks,
V.Cell!