Hi Steve

but Id need to get all the
data into one Workbook.

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

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

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Steve" wrote in message ...
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 Id 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