Without VBA, simply select all sheets by 1) click on first sheet tab,
2) hold down shift, 3) click on last sheet tab. This will "group" the
sheets. Now what ever you type in a cell in the first sheet will also
be in all of the other sheets in the same cell.

Click any sheet to "ungroup" them.

- John
www.JohnMichl.com