Create a Dependent Drop-Down List

Hello, I'm trying to create a production schedule sheet for work and I'm having trouble creating a dependent drop-down list. I'm familiar with creating typical/simple drop-down lists, but I need help with some of the more advanced tasks (advanced for me anyway!). I've attached a sample sheet to illustrate what I'm looking to accomplish.

I have a list of customers and jobs on one tab (illustrated on my sheet as car makes & models). My production schedule is on a separate tab. The schedule will be a table of anywhere from 50-500 rows. I'd like to have my customers (MAKES) appear as a drop-down list (which I am able to accomplish), while the jobs (MODELS) column is a drop-down list of jobs that is dependent on which customer is picked. For example, if I choose 'Chevrolet' from the MAKE column in my production list, I'd like the list in the MODEL column to be a drop-down list of only 'Tahoe', 'Malibu' or 'Equinox'. In the next row, if I choose 'Honda' as the MAKE, I'd like the list in the MODEL column to be a drop-down list of only 'Accord' or 'Pilot'.

I've tried using 'indirect' functions and 'filter' functions within the Data Validation settings but I haven't had any luck. Any help would be greatly appreciated.

I apologize if this is already shown on a pre-existing thread. I tried to look for my specific answer, but was unable to find it.

Thank you!
James