Cascading drop down list

Gleen Kennedy,
You are right. I am not satisfied with that solution either. I have been stuck on that for days and that is the best I could find so far, besides a script on Google Sheets (which is exactly what I want, but I need it for Excel unfortunately).
I have only been using Excel for about a month, so I have a lot to learn.

I did find this other workbook that someone posted on another forum years ago. They auto populate information from one data table onto helper columns and use that as the data source. But I do not know how to tailor it to this person's situation, or my own for that matter, or if that's even what they are asking for.

I'm just throwing stuff out there trying to help since others have helped me.

Here is that workbook I found, I am not sure if it will be of any help as I mentioned. I apologize if it's useless to you.