Creating Commission /Fee Calculator

I currently have a spreadsheet which details the Commission earnt and fees due for each trade I do, depending on which particular client I have traded with. I have probably around 30 clients. The spreadsheet is very small and I enter 7 pieces of information to create the commission and fees, however what each client pays in commission and fees is different depending on who they are and the trade type.

I want the sheet to be automated, where the sheet correctly calculates everything.

I can detail the information for each client that is needed to create the automated sheet. I can give the fixed conditions that each client pays for you to create this. I am happy to send a photo of what I currently have, which is very basic.

I also want the ability to be able to add new clients/new conditions in the future to this once it is setup on my own easily

In addition to this. Once this is done, I would also like the information created to be mirrored in a slightly different format which I can give you a copy of, so I can check the commission earnt and fees due compared to a statement i receive every morning

When this is complete I intend to use this to create further spreadsheets related to this information, which can be part of a new job you can do for me, if this is successful and what I am looking for