more efficient formula using index and match for breakdown of values in one cell

I have a datasheet of puchase orders which are itemised according to taxes paid .

However when there are different purchase orders but same itemised number for taxes, It's a chore to do this manually as attached in yellow and in blue the manual breakdown and brown the expected results which should tally with the totals for each itemised taxes

The data goes up to 1000 rows !!!

Take note the taxes are on sheet 2 but for ease of understanding I have put it on same sheet and label it at end of data.

Can anyone help to have a more efficient formula in one cell for each taxes

See attached column B8.B9,B10 AND B19 B20

AND TAX CODE M8 and M14 .


Ihave to make make extra calculation from column H to K for a complete breakdown per itemised tax because there are different purchase orders associated to their itemised tax ,
this is the issues, looking a formula that can embed a single calculation without doing manual formula from column H to k.

In summing it should tally as example item 13 in red

13 1699 1954 expected results

12088 13 72.55 1699 1954 485.08 557.88
12241 13 181.56 1699 1954 1,213.92 1,396.12

Also itemised column 7 AND 9 shows same issues ??

With one puchase order and 1 itmised Tax the formual index and match works fine but different purchase orders same itemised tax is the issue

For item 13 break down tax should be 485.08 and 1213.92= total 13 tax 1699 and vat 577.88 & 1396.12= 1954 in tax colum itemised 13
Actuallu reading taotal 1699 and 1954 for both itmised which is incorrect

I have amended the tax sheet with the expected results in column tax and vat.
The previous file was a bit confusing to understand,

I have to do this manually

=SUM(C20+C21) sum amount manually for item 13
=C20/$N$17*$H$16 =C20/$N$17*$I$16 then for item 13 amount with different purchase orders divide by total amount fot item purchase orders* tax (called prorating) so that total amount tally with amount tax sheet
=C21/$N$17*$H$16 =C21/$N$17*$I$16

That is sum amount