Auto Populate a Yearly Calendar

Hi all,

I'm a newly joined member after reading through quite a lot of posts that relate to what I would like to do. I haven't found anything that matches what I am looking for a solution to.

Please tell me if this should go somewhere else.

I am hoping to auto fill dates on a yearly calendar with a name and task from two columns by date. This data sheets will be kept by month.

The idea would be that if a due date says 02/07/15 for a name and task, this would auto fill in the box of the yearly calendar for that date.

There may be times when there is more than one task due on a date.
I've attached two files that demonstrate what I am talking about (I hope). Again, if this should go elsewhere please tell me.