Add totals in different files/workbooks?

[Roger]

I am trying to add various worksheets saved in different files in Excel. How
do I do it?

 

[Ron de Bruin]

Hi Roger

I am not sure what you want

Start here
http://www.rondebruin.nl/copy3.htm