I have a workbook with 14 worksheets.


Sheet 1 Cell A5 C6*B7

Sheet 3 Cell C6 5
Sheet 3 Cell B7 9
Sheet 3 Cell D15 4


Sheet 3 Cell A5 = ?????

Want Sheet 3 Cell 5 to look at Sheet 1 Cell A5 get the formula (C6*B7) and
use the numbers from the cells C5 and B7 from Sheet 3 and end up with 45 in
Sheet3 Cell A5.

Also If I Change the formuls in Sheet 1 Cell A5 to C6*D15 it would
change Sheet3 Cell A5 to 20.

Rather than copying the new formula to each worksheet, One sheet would hold
the formulas to do the calcs. All the worksheets would be the same layout so
the called cells would be the same. Does that make sense to anyone. Can
it be done in Excel without programing (VB) or Macros?

Thanks.