Consolidating Information from Multiple Worksheets into One Calendar

I have been searching forums for the past two weeks and have been unable to uncover a solution to my issue. I work in a Probation Department and need to be able to track several types of schedulesby consolidating 6 or so calendars into one. I have approximately 40 people that could be schedule to do or be somewhere in a given day and need a way to display that information in one location. We do not have Outlook and use Lotus Notes instead. I am also workling with Excel 2003. The calendar would have to be user friendly since some of the folks are not very savvy. Any help or direction would be greatly appreciated!

Can you upload an example?

Sure- I am attaching a spreadsheet that includes worksheets for each schedule that I need. It also includes a sheet called Formatting so you can see how I would like the final sheet to look. Thanks so much!