I am set an assignment for capital expenditure and i need to create an input, formulas and output in different worksheets. The reason why we have to use multiple worksheets is we want to be able to change a figure in the input worksheet and in doing so the output worksheet should change at the result of this.
For example say in the input worksheet i have a cell with IRR=40
and in the formulas worksheet i have 1/(0.5 + IRR)^1 in one of the cells
if i change 40 to 41 then the output worksheet will contain a different answer

I want help on transfering the input number (IRR) from the input worksheet to the formula worksheet, i also want the formula to not display the answer, but display the answer in the output worksheet. I am having a little trouble working out how this can be done.