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