You can "group" the sheets by right-clicking on one and "Select all sheets" or
by using CTRL + Click for non-contiguous sheets or SHIFT + Click for
contiguous sheets.

What you do to one will be done to all in the "group".

IMPORTANT WARNING.........do not forget to right-click and "ungroup" when work
is complete.


Gord Dibben Excel MVP

On Tue, 6 Sep 2005 17:11:35 -0700, "mlofton"
wrote:

How do I make changes to numersous duplicate worksheets witout having to
change each one indivdually. I have 5 of the same worksheets and need to
make changes periodically. I would like to have 1 master and the rest
copies. Thanks