How to make a drop down list based on static values of cells in column beside list

I have tried looking for the answer to this, but I keep on getting results for contextual multiple drop down lists, which is NOT what I want

I work in automotive transportation. We just discovered that we have some information that is not linking correctly in the transportation program that we use. We can use an excel file to upload the corrections, but I need to get it set up first

Basically have a list of customer invoice numbers that I need to match to our internal order numbers. I can pull information on the moves based on the vehicle vin number. The only problem is that the only common information between the list from the customer and the information I can pull are the vin numbers and the prices. Neither of which are unique in either list, as many of these we have moved multiple times. Even the dates only generally matched as the invoice date can be several days after delivery and there are even some vehicles that have been moved multiple times on the same invoice

I can sort things to group the vins, and then match information by eye. But I am trying to make that a bit easier. What I would like to do is have a column that has drop down list, with the values in the list based on the vin number that is in that row

So I want excel to look at the vin in that row, then search the other list (on another sheet) for the same vin and populate the list with the order numbers that match

Not sure if it is possible or if what I am saying makes sense, but I figured I would ask before I start having to fix about 13k records fully manually. As it is because of the duplicate information I do not think I can automate or use functions to help with anything else other than arranging the order of the information for the upload

I am using legacy excel 2019

Edit:

I see that I was not clear enough and need to show some examples.

Here is the information that I can pull from our program. I can actually pull quite a bit more, but none of it will match with the other sheet. Note that this is for one (fake) VIN. There are a few thousand individual VINS

Here is the information about the invoices:

Note, the Tax line is currently not entered for the Orders. Once the Invoices are matched up, it will be. Even if it were, it would be another column on the same line as the Order in the first sheet. This is also all of the information that I can get for this sheet. Note that not only are the VINS duplicated, for this one was are two invoices that are duplicated, and even a couple of moves on the same date

But what I have to do (with slightly different order of the columns and a bit other other information, but that is easy), is make it look like this:

So my question is, it make it easier, can I make a drop down in column F of the second table where it is ONLY populated by the Order IDs for the VIN in column A. If it was a different VIN, it would have different order numbers.

If course, if someone can come up with a way of matching fully, it would be even better, but between the duplicates, including of the Invoice numbers, and the dates being off, I am not expecting it. I just want to make it a bit easier than copy and pasting the Order Numbers across

^{Table formatting by ExcelToReddit}