VBA Calendar Help-Holidays

Hello,

I have posted before about a calendar but I have a different question now. I have a calendar (attached) that has a different month on every sheet (2 years worth). The dates automatically populate based off the year entered in cell 'January!K14'. On the 25th sheet labeled 'Holidays' there is a list of Holiday names and two columns with formulas to derive the dates of each holiday. What I would like to do with VBA is take the name of the holiday and place it in the appropriate day on the calendar. For example, in 2017 Thanksgiving is on 11/23/2017. I would like cell 6 rows below the date title ('November!E46') to automatically populate with the text in cell 'Holidays!A9' because 'Holiday!B9' is equal to 'November!E40'.

Any help would be greatly appreciated.

Bernie,

Thank you for responding so quickly! I am having issues getting this to work. Any suggestions? Could you also throw in some comments so I can follow what it should be doing?

Thanks,
Drew

That is perfect! Thank You.