Auto populate vacation calendar dates per employee

Hello,

I have an excel sheet that I am working on and will attach to this post. On the Calendar tab I was hoping, or wondering how I could tie that in to an employee list, so that when I click from a drop down, or if it finds the employee name, it will auto-populate a certain date range in the calendar showing this is when they had PTO, Unscheduled Absence, FMLA, etc....

The excel sheet has the questions highlighted in orange in which I am trying to accomplish.

HolidayCalendar.xlsx

**side note... the date range is pulled over from a scheduling system as is, in the Leave Dates column on Season 1 and 2012 tabs**

Anyone??? I would appreciate any assistance!