Thanks all for the responses. I would like to extend the problem. Is
there a way for me to sum the same cell from other sheets (with the
same name), but from different workbooks....all to my summary page.
Again, the number of input sheets (i.e. workbooks) is unknown. If I
can do this I would not have to copy all the input sheets into my
Summary workbook.


--
AlZee
------------------------------------------------------------------------
AlZee's Profile: http://www.excelforum.com/member.php...o&userid=15906
View this thread: http://www.excelforum.com/showthread...hreadid=273888