Need to be able to change contents of a dropdown based on selection in another dd

I have a bid sheet that I am trying to autofill with various dropdowns to make filling them out more streamlined for my PMs. We have about ten different clients that we do bids for, so I need them to be able to point and click as much as they can.

Attached is a sample workbook. Sheet 1 is the bid sheet, sheet 2 and 3 are Client sheets with line item data. What I need is for the A column on the bid sheet to populate a drop down with the appropriate line items pulled from the Client sheet based on what client name is selected in B14. If Client 1 is selected in B14, I need column A to have the list of their line items available for selection. If Client 2 is selected, I need THEIR list in column A. I cannot for the life of me make this happen. I've tried vlookup and Index/match but this seems to be a bit over my head. TIA.

Oh man this is EXACTLY what I was going for!!!!! Thank you so much. Now all I have to do is get the trade category and unit dropdowns going but those are super simple Named Ranges that don't change from client to client so that won't be hard. Thanks again, this is going to make everyone's lives so much easier.