Goal Seek for achieving two simultaneous goals

I have a format for bifurcating sales amount among different tax slabs (2.5%, 12.5%, 18% & 28%)

Net values in column D represent the basic value, VAT amount values in column E are subsequent VAT values (Net X Rate)

I have the following values that are known:
Total Net Amount (Cell D1)
Total Vat Amount (Cell E1)

The Result expected:
Sum of Current Net Values = Cell D2
Sum of VAT AMount Values = Cell E2

Condition: The amounts within D6 to D9 need to be adjusted in such a way that subsequent VAT Amount total is also equal to the total of VAT known (E2)

I have used the macro for Goal seek but it allows to change only 1 set of values. There are multiple such calculations required on different occassions.

Could you help me find a better way to do this?