auto populate a calendar template with travel schedules

Hi, I am attempting to create a tool in excel 2010 that will track travel schedules for a large global team. The tool would auto populate a calendar template with details that are entered on a separte worksheet. The first sheet has 6 columns: Name, Departure Date, Return Date, Location, Purpose, and Role. Once the data is input on the first worksheet, I need to make it visual and populate a calendar template such that the Name, Location, and Purpose are populated on the days corresponding to all days between and including Departure Date and Return Date.

I'm really struggling and any help anyone could give would be appreciated..Thank you in advance.