Linking Numbers from one sheet to another

[Kenneth]

I'm trying to figure out hoe I could link a number to
several other worksheets. I.E. if I typed the number 15.76
into B6, how could I get it to copy that number,
automatically, to eight other sheets in their B6 fields.

 

[Earl Kiosterud]

Kenneth,

Select the sheets to get the B6 value from the source sheet (Use Shift
and/or Ctrl as necessary).
Select B6 ( on any of the selected sheets).
Type =
Select the source sheet, then the B6 cell.
Press Ctrl-Enter

Only B6 in the source sheet should be changed. If a user types a value into
one of the other B6 cells, it will replace the link to the source sheet.