Auto populate details from one sheet into yearly calendar

[macydee]

Hoping someone can help my intermediate skills! I am attempting to link data from one worksheet based on date to a table calendar that encompasses the entire year. In my attachment:

On the Projects tab I want Implementation Date (Column G) to populate the data from the Project Column (Column A) on the associated date from the Calendar tab.

I am afraid because of the format of this calendar it won't work. I was thinking some type of Vlookup with IF formulas but I'm not sure how to make it import into the calendar table. I am open to other calendar types but a yearly view with dates is necessary.