Taking Data from Multiple Different Worksheets and Putting into a Calendar

[psuedodragon]

Okay, so this is a bit of a bulky question and I hope I can express myself well enough that it makes sense to somebody.

I have two worksheets, one is a list of students currently enrolled (as well as those registered but on the wait list), while the other is a list of volunteers who teach or help teach the classes.

I want to combine information from these two sheets/tables and put them into a calendar/schedule.

The student list/table looks like:

Registered On | Name | Status | Enrolled On | Level | Class | Start Date | End Date | Future Action | Phone Number
October 01/13 | Mark | Enrolled | October 8/13 | B | AM | October 10/13 | December 20/13 | Advance | 000-000-0000
October 01/13 | Jane | Enrolled | October 8/13 | I | PM | October 10/13 | December 20/13 | Leave | 000-000-0000
December 20/13 | Mark | Enrolled | January 01/14 | I | AM | January 06/14 | March 07/14 | ---- | 000-000-0000
December 20/13 | Sasha | Enrolled | January 01/14 | B | AM | January 06/14 | March 07/14 | ---- | 000-000-0000
December 20/13 | Jason | Enrolled | January 01/14 | B | PM | January 06/14 | March 07/14 | ---- | 000-000-0000
December 20/13 | Beth | Waiting | ---- | I | --- | ---- | ---- | ---- | 000-000-0000

and the volunteer list looks like this:

Name | Phone Number | Email Address | Job Description | Day of Week | Time | Class | Start Date | End Date
Susan | 000-000-0000 | email@email.com | Teacher | Monday | AM | B | January 06/14 | March 07/14
Darcy | 000-000-0000 | email@email.com | Helper | Tuesday | PM| I | January 06/14 | March 07/14
Rich | 000-000-0000 | email@email.com | Teacher | Wednesday | AM/PM | B | January 06/14 | March 07/14

obviously with more data in each of them, but that should give you an idea of what I am working with.

I want to put the information into a new chart/calendar... Right now it looks like:

January 6th - March 7th Classes
---- |Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday
9:30 AM | Beginner (merged across)
Teacher | ---- | (name) | (name) | (name) | (name) | (name) | ----
Helper | ---- | (name) | (name) | (name) | (name) | (name) | ----
Student | ---- | (name) | (name) | (name) | (name) | (name) | ----
---- | ---- | (name) | (name) | (name) | (name) | (name) | ----
---- | ---- | (name) | (name) | (name) | (name) | (name) | ----
9:30 AM | Intermediate (merged across)
Teacher | ---- | (name) | (name) | (name) | (name) | (name) | ----
Helper | ---- | (name) | (name) | (name) | (name) | (name) | ----
Student | ---- | (name) | (name) | (name) | (name) | (name) | ----
---- | ---- | (name) | (name) | (name) | (name) | (name) | ----
---- | ---- | (name) | (name) | (name) | (name) | (name) | ----
11:30 AM | Beginner (merged across)
Teacher | ---- | (name) | (name) | (name) | (name) | (name) | ----
Helper | ---- | (name) | (name) | (name) | (name) | (name) | ----
Student | ---- | (name) | (name) | (name) | (name) | (name) | ----
---- | ---- | (name) | (name) | (name) | (name) | (name) | ----
---- | ---- | (name) | (name) | (name) | (name) | (name) | ----
11:30 AM | Intermediate (merged across)
Teacher | ---- | (name) | (name) | (name) | (name) | (name) | ----
Helper | ---- | (name) | (name) | (name) | (name) | (name) | ----
Student | ---- | (name) | (name) | (name) | (name) | (name) | ----
---- | ---- | (name) | (name) | (name) | (name) | (name) | ----
---- | ---- | (name) | (name) | (name) | (name) | (name) | ----


So I'm wanting to be able to use a formula or something to pull the relevant names from the previous two worksheets...

I can't figure out how to lookup a name based on what time (AM or PM) and level/class (B or I) they're signed up for, and the added issue of Teacher vs. Helper and Day of the Week for the Volunteers.

Any suggestions?

Thanks!