Becky

If what you want to change is all in the same place on each sheet then you
can group them.

Click on one sheet tab, hold shift key down and select another you will
notice all in between are now selected. Everything you now do to a sheet
will reflect in them all.

Ctrl and select a tab will select non-contiguous sheets. Right click on one
and select ungroup when you are done or click on one not selected will also
do it

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS

"becky" wrote in message
...
My boss has an existing workbook with several worksheets in it. He wants
me
to add several rows. Is there any way I can make the changes in one sheet,
then have the rest of the sheets automatically updated? The rows need to
contain formulas. I would appreciate any help you could give me.
Thanks.