Combining 2 sheets into 1 (vlookup? array?)

[seriousallthetime]

Before we start, I know I can do this via vlookup but it is massively time consuming. You'll see why.

The goal: to figure out when my product will arrive at my assembly centers.

The issue:
I have a spreadsheet from my freight forwarder. It looks like this:

PO	SKU	QTY	Depart Date	Destination	Arrival Date	Shipment Status
4246607896, 4246618896, 4246619896, 4246620896, 4246621896, 4246627896, 4246629896 <tbody> </tbody>			1/1/2018	Florida	2/19/18	Awaiting Arrival
4252919896, 4252921896 <tbody> </tbody>			2/5/2018	Ohio	9/25/18	Awaiting Arrival
2008788898, 2008791898, 2008796898, 2008797898 <tbody> </tbody>			3/5/2018	Washington	12/5/18	Awaiting Arrival

<tbody>
</tbody>

I have a spreadsheet that looks like this:

PO	SKU	QTY
4246607896	212160008 <tbody> </tbody>	12
4246618896	212160004	4
4246618896	212160006	6
425919896	212160025	5
425919896	212160024	15

<tbody>
</tbody>

How do I combine these two into some kind of coherent document that can tell me when stuff is coming in? Obviously there are a whole lot more POs, several hundred in fact. Way to many to do by hand.

Every PO in the first sheet is represented on the second sheet. Every PO can have one or more SKUs on it, all with different quantities. The first sheet gives me the PO number and all of the inbound timeline data. The second sheet gives me all of the PO content data. I need them on one sheet. How?

 

[mrshl9898]

Assuming the second set of PO's are in column A and the first set of data is on Sheet1:


=INDEX(Sheet1!A:F,MATCH("*"&A2&"*",Sheet1!A:A,0),6)

 

[seriousallthetime]

Assuming the second set of PO's are in column A and the first set of data is on Sheet1:


=INDEX(Sheet1!A:F,MATCH("*"&A2&"*",Sheet1!A:A,0),6)

Thank you! This worked perfectly!