multiple vaules from different sheets in one cell of another
 

im attempting to use excel 2000 to create a schedule for my department. The
idea is that there are multiple supervisors each with their own schedules.
There is also a monthly schedule that we want to show the assignments from
the seperate division schedules. Im looking for an equation that will allow
the monthly schedule to pull data from the division schedules. the amount
displayed on the monthly schedule should represent whatever information is
entered first in any of the division schedules. In other words... if Jane is
working for supervisor A, supervisor B will not be able to schedule her to
work for him... and the fact that Jane is working for supervisor A will be
displayed on the monthly schedule... i thank you for any help