First of all, I don't think I am smart enough to go coding.
Being that, is there anyway to build calculation functions in Sheet2 and
list possible input in Sheet1 and automatically getting values under
different inputs?
For example, I put equity valuation calculations on Sheet2.
A1 of Sheet2 is the earning growth rate assumption, which drives all the
equity valuation calculations.
In sheet1, can I input 10 different expected growth rates in A1:A10 and get
equity values on B1:B10 (based on the calculations on Sheet2)?
I understand that creating a table can be helpful. But Table does not work
in separate sheets. Plus, if I want other parameters in the calculations in
addition to the equity value, I have to create other tables.

Appreciate your help!

Rt