How to set up dynamic cells based on calculations in same sheet?

I need help with setting up dynamic cells that a) pull from another cell and b) use a calculation on top of it.

These are tiered bonus calculations paid out based on percentage scores on an audit. I cannot figure out how to have the totals in each tier populated correctly from the actual total or how to adjust the totals earned based on the ranges of scores.

In the sheet I’ve color coded the cells that will continue to be manual input, that I’d like to be dynamic, and that are reference items used in the calculations/tallying.