XLOOKUP multiple tables

[Kupka8]

I am trying to create a snapshot of classes that are in session or going to be in session for the next 8 weeks.  I have a chart showing the classes, but I want a way to automatically search through the classes on the 2nd sheet of the excel document to pull the correct dates and corresponding information.  

[#2]

removed 

[#3]

Is there a way to keep the classes together? All the A classes together and all the B classes together etc?

[#4]

I want the classes that are happening in the current week to 8 weeks out, is there a way to do that? I don't want to show classes that are happening past those 8 weeks, or prior to the current week. I am trying to make a sheet that I can keep adding classes to as the months progress.

[#5]

removed

[#6]

It is pulling classes that are starting one year out. It should be pulling classes A-001 - A-004, B-002 - B-010, C-001 - C-010 based off of the current date. Is there a way to do that?