hi robert,

thx for your response.
I have tried that before but the problem with that is when u drag the
formula the sheet numbers dont change eg : Sheet1!D27+Sheet2!D27 when dragged
will change to Sheet1!D28+Sheet2!D28 or Sheet1!E27+Sheet2!E27. Now this
becomes a problem bcs u have hundreds of sheets to manage..u remove some u
add some. so its kinda painful. Is there anyway out of this?

"robert111" wrote:


in cell A1 of your master sheet enter

=sheet1!A1 + sheet2!A1 + Sheet3!A1 etc etc


--
robert111
------------------------------------------------------------------------
robert111's Profile: http://www.excelforum.com/member.php...o&userid=31996
View this thread: http://www.excelforum.com/showthread...hreadid=564639