Combine totals field from multiple workbooks into a new 'totals' workbook

[ratman and bobbin]

There is a workbook for each sales area. These workbooks have a total sales
figure. I am looking to create a separate workbook which
will have these figures included and be updated as the sales workbooks are
updated.

Hope that is clear and any help gratefully received!
Geoff

 

[Ron de Bruin]

If you know the cell address ?

See
http://www.rondebruin.nl/summary2.htm

If not post back

 

[ratman and bobbin]

Ron

Your first example seems to fit the bill. Will try this and post back.
Many thanks for the response
Geoff