Calculation of best share percentage for taxes returns

I will explain you what I try to do. We got an entreprise with 4 associates.
Each one have a pourcentage of share of the income that can vary. Of course changing their share pourcentage will affect their return positively or negativly,
but will affect other associate also as pourcentage must alway remain 100% for the sum of all associate..

Knowing that I have free to put any pourcentage for any associat, I want to calculate the best pourcentage each one need to have to maximize total income.


Here what I got in my excel file. I simulate each pourcentage on tax software programme to get the number coresponding to the pourcentage.

Column A
A have pourcentage 1 to 100 of the share of AsoociateA,

Column B
have the ammout of tax returned coresponding to this pourcentage for associateA.

Column C
A have pourcentage 1 to 100 of the share of AsoociateB,

Column D
have the ammout of tax returned coresponding to this pourcentage for associateB.

Column E
A have pourcentage 1 to 100 of the share of AsoociateC,

Column F
have the ammout of tax returned coresponding to this pourcentage for associateC.

Column G
A have pourcentage 1 to 100 of the share of AsoociateD,

Column H
have the ammout of tax returned coresponding to this pourcentage for associateD.

KNowing that that i try to find the pourcentage to choose in A,C,E,G that give the best sum of coresponding B,D,F,H when total of A, C, E, G, what is your suggestion to do so?

thanks you for your help.

here the file, flr clarite i changed to put only one column with pou rcentage as it was not usefull to put it 3 time. Data are random for test purpose.
Nouveau Microsoft Excel Worksheet (8).xlsx

On excel file column A is the porucentage of share. next 4 row are name of the partner and the tax return he gonna get with that pourcentage.
As its memebership total pourcentage must be 100%. so if all equal, each one will get 25%, but sharing equal between partcher the share didt give optimal return actually.
maybe its better partner A to get 10%, B 50%, C 30% and D 10%... i need find out the best posible outcome.

So basicly i need to find a combinaison of share that give 100% of shar0e dist0ributed be0tw0een the partner that and gonna give the best total income.

Nouveau Microsoft Excel Worksheet (8).xlsx here its a exemple with explanation so you can easy understand.

its not what i looking for. I want to find the best combinaison, not having to test all of them one by one, that why i provided a vba code but it seem dont work corectly.