few cells info in one cell

[Erenstas]

Hello,

I have such info in a table (provider, purchase order nr, date when it has to arrive , comapany inside code for this part, part numeber(providers) quantity
[TABLE="width: 1131"]
<tbody>[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]MOUSER ELECTRONICS ( ES)[/TD]
[TD]ERGR180829-1276[/TD]
[TD="align: right"][/TD]
[TD="align: right"]2018.09.17[/TD]
[TD][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]
[TD]12R-00548[/TD]
[TD]MMSZ5246B-7-F[/TD]
[TD][/TD]
[TD="align: right"]10[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


and info from provider (purchase order nr, part number, comapny inside code, quantity, confirmed delivery date)
[TABLE="width: 1131"]
<tbody>[TR]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 1038"]
<tbody>[TR]
[TD]ERGR180829-1276/1[/TD]
[TD]MMSZ5246B-7-F[/TD]
[TD]012R-00548[/TD]
[TD="align: right"]7[/TD]
[TD][/TD]
[TD="align: right"]20181015[/TD]
[/TR]
</tbody>[/TABLE]

[TABLE="width: 1038"]
<tbody>[TR]
[TD]ERGR180829-1276/2[/TD]
[TD]MMSZ5246B-7-F[/TD]
[TD]012R-00548[/TD]
[TD="align: right"]3[/TD]
[TD][/TD]
[TD="align: right"]20181025[/TD]
[/TR]
</tbody>[/TABLE]

I have tried lot of formulas, with ifs, match, index and so on, but formula gets too big, and it doesn't solve problem.

I need to get value from suplier table, on what dates we are getting this part ( we want it on one date, thei confirmed on other, most of the time these date doesnt match). I have info PO number, and inside code (I believe, that is the best case to use these two), but there are a problem that Pn doesn;t always match, I know hot it starts, and how much symbols it includes. also there may be partly shipment, like in example 7pcs arrives first, and later 3pcs, but I have info in one line that all quantity arrives at the same time, and I get just first date...

any sugestions, how can I solve this, is it better tu use formulas, or in this case better to try macro?