Google Sheets Match / Query from Multiple Dynamic Dropdowns

I have a Sheet that I need to query data from another tab to match 4 if/or dynamic drop downs and 1 if/and dynamic dropdown. It's a stumper on my part. I've attached the sheet as well as a 4 min explanation video. Thanks in advance!

Sheet:

https://docs.google.com/spreadsheets/d/1rUtTJkvFKFI8Q6lnRtxNpky5bYe9u8BZBok0M8hwZ7o/edit?usp=sharing

Video:

https://www.loom.com/share/392fd41c5c0844d6ad7df308d1af9f6c