Creating a Calculator

Hello, I would like to create a sheet that calculates incentives for my staff.

I created a sheet with subtables, one for the base calculation rate of different incentive types, which I want to fill with default values; The other I would like to populate the subtable from data in another sheet with different entries.

Been studying on this topic and couldnt find a way to do it. Is it even possible?
Thanks in advance.


To better understand your ideal workflow, could you please provide us with related data examples, the ideal formula calculations, and all steps of your ideal workflow first?