Supreme bragging rights to the savviest Excel Guru!

I found many dynamic calendar templates that pull events into their respective month dates. Challenge: can a dynamic calendar be automatically populated with multiple events, spanning multiple dates and color coded by business unit? I don't want the same event title repeated on June 10, 11, 12, 13. I'd like to have the event title span the dates in the month and color coded--if possible. Attachment 817733