Group Data With Changing Criteria

I have created a worksheet with criteria for grouping the students. If the teacher selects 1 high, 1 med, 1 low in each group based on the conflict lesson plan (or test #2 or whatever assessment the teacher chooses), then I want the spreadsheet to create groups with the students names using the table corresponding with the assessment they choose. (I.e. the conflict table or the test #2 table)

So group one will list one high student, 1 med, 1 low etc....

Initially I was going to use lookup_occurrence to do this; however, I ran into a problem.

When a teacher selects 1 high, 1 med, 1 low, then cell B8 says high, cell B9 says med, cell B10 says low. And then I was going to put a lookup_occurrence in the corresponding c columns to find the first occurrence of those values for group one.

However the problem is this if a teacher selects all high, all med, all low in a group then cell B8 will say high still, but cell B9 will say HIGH not med now, which it does, but then the corresponding lookup formula will need to be the SECOND occurrence of the value in B9 instead of the first as before.

So you see this is a problem. I now have NO IDEA how to generate these groups since the lookup_occurrence formula idea will not work.

I also have a problem separating the periods. If the teacher chooses to group the students based on the first lesson plan, I have told it to look up the table 'E_term 1'!Card1. Problem is Card1 is a table with ALL 8 periods with a few lines separating each period. If I go in and rename each card by period as well, it is going to be a nightmare.

Attached is a sample of TWO pages from my workbook: the groupings page, and the e_term 1 page.

How do I create groups based on changing group types, periods, and assessments?