There is no need for macro
for e.g.m all the sheet there are numbers in A1, B1 and C1

pressing shift key click tabs of al the sheets one by one
and in any sheet in front of you type in D1
=sum(a1:C1) and hit enter
CLICK TAB OF ANY SHEET.

Now see all the sheet whether you get what you want.

I actually meant adding a row like inserting a row. Not adding values. Sorry if I was unclear. I need to insert a row on one page and have that automatically insert a row of another page. Thanks!

Use the same tactics. shift+tabs one by one and insert row.

Hi erin_ASM
select all the sheets first and then insert a row in any of the sheets
This will insert a row in all the worksheets at the same location Winners�are�losers�who�got�up�and�gave�it�one�more�try.�-Den­nis�DeYoung
My�Interests�are�financial�Modelling�and�custom�excel�develo­pment.

Thanks!