Changing multiple cell values from multiple worksheets

[sunsetace]

I have a workbook with several worksheets containing different mortgage calculators.

I want to be able to change certain variables (Loan Amount, Interest Rate, Term) from any worksheet, and have all the other worksheets automatically update, regardless of what worksheet the change is made from.

Example: I enter the loan amount in Worksheet #2 and Worksheets 3, 4, 5
automatically update, and then be able to enter the loan amount from Woksheet # 4 and Worksheets 2, 3, 5 automatically update.

Not sure if I need a formula, macro, VBL...not that sophisticated with Excel...any help would be greatly appreciated.

 

[Robert Mika]

If you add a loan in Sheet 2 and then in worksheet 4 at which sheet you want your formula to look at?

You can use nested IF in form
=IF(Sheet2!A2="",Sheet4!A2,IF(.... and so one.

I this what you after?

 

[sunsetace]

Thanks Robert,

The cells in question are user input cells, not formulas.

Let's say on W1 you enter 175,000 for the loan amount, I want "the loan amount" to auto update on the other worksheets where there is an input for loan amount, and there are multiple cells for "loan Amount" within the workbook. I want all the cells to update, regardless of which cell is used to change the input amount...hope that clears it up.

I'm not familiar with nested IF, but it sounds like it may work for this situation, you input would be greatly appreciated.