I have schedules (in the format of the "schedule" tab) of the attached worksheet
I have some administrative data (under the "data" tab--format is kind of immaterial)
I want to generate a calendar (generally in the format of the "calendar" tab)
 
I would like
-for the calendar to run from january 1 through the end of the year, automatically generating its own day and week numbers, days of the week, and months of the year
-for employees to be listed in the order that they're listed on the data tab, with distinction between teams (in the excel, i used thicker lines and color) and between employees (in the excel, i used lines)
-for the calendar to dynamically adjust to more or less employees (ie, it figures out that everyone working for Anne works for Anne, and Anne isn't limited to just three employees)
-for the calendar to dynamically adjust to more or less tasks (ie, not limited to one task for all employees, two tasks for all employees, etc)