I'm not clear on how this works, but I applaud your effort at automation. So let me see if I can figure this out.

On sheet 2, I see what appears to be two schedules, both are Week 2. Is that right or should one be Week 1?

On sheet 1, there are tables with "buckets" of half hour time slots. The headings of Sunshine, Starlight, and Rainbow. Are these the three rooms? If so, is it your intention then to populate these buckets with personnel based on the schedules on sheet 2?