Vlookup within Vlookups

Good morning

I have attached my spreadsheet as it is so far.

I'm trying to have a dropdown list of consignee's that are associated to the shipper.

The shipper short code selects the shippers address.
Then you select the contact from selected shipper. (Thanks to Lee yesterday for that)

Now based on the shipper that is selected, each shipper may have upto 50 different consignee's that i want listed.

If you look at second sheet and scroll along the top until you reach customer A, customer B, this is where i'm going to list all the particulars that are relevant to each consignee (as per list 1 column left of customer a).

On some customers, every single row could be filled in and this information needs to be transferred into the first sheet.

All i need to know (phew) is how to link the customer's consignee to the customer.

Hope you follow my description of the challenge.

Thanks for your time
StuartEade