Sum data from multiple Workbooks.

[Steve]

Is there a way to sum data from multiple Workbooks? I need to sum a cell
from multiple Workbooks to get a yearly total. Unfortunately, the person who
entered the data made many (200+) Workbooks rather than just adding another
worksheet to the existing workbook.

I believe I can use the 3-D reference formula but I’d need to get all the
data into one Workbook. If I already had all the data in one Workbook, I
would not have a problem. But…

Any help would be/is greatly appreciated.

Steve

 

[Ron de Bruin]

Hi Steve

but I’d need to get all the
data into one Workbook.

Try this
http://www.rondebruin.nl/summary2.htm

Or
http://www.rondebruin.nl/copy3.htm