Populate name/vacation date information into calendar format in separate tab

I found a similar example thread but have lost the link...I know that user Pete_UK generated the sample file "ef159_Vacation_Calendar", attached here, as a reference and it gave me hope but I don't have the knowledge to integrate it into the sheet I have created, also attached. (Primarily as my source content runs across the columns rather than down the rows.)

I would like to link the vacation dates and employee name indicated on the appropriate dates in a separate calendar tab. My goal is to have all the primary tabs with information hidden so that only the calendar tab is visible to employees for vacation planning purposes. I do not want any of the other types of leave to be shown in the calendar as that is not information that all employees should see. I'm using Excel 2010 and would appreciate any assistance!