There is the easy way to do this, and the hard way. The easy way would
to be to link all 10 cells  to the same input from another cell  or a
dialog box, and make the 10 cells protected so they couldn't be
overwritten in any other way,

But if you wanted the hard way, you could put code in the Change event
on each worksheet to write the updated value to all 9 other sheets.