Hi,
take a look at Ron de Bruin web
http://www.rondebruin.nl/copy2.htm
"CWO4 Dave Mann" wrote:
I have a set of many single page worksheets with calculations; I want to make
a single Workbook using all of those pages. Then I want to extract data from
a certain cell on each Worksheet and SUM that data on the last page of the
Workbook.