automatically move cell data in 1 workbook to another workbook

[Genesis]

I have several workbooks with similar cell information containing totals. I
want to create a new sheet in one of these workbooks where the total in
similar cells in each different workbook can be viewed and manipulated
automatically on that sheet.

As it is now, I have to open each workbook get the total from the
appropriate cell and use a calculator to create a grande total.

Thanks
Tom

 

[Ron de Bruin]

Hi Genesis

Try this example that create links to a the cell in each workbook
http://www.rondebruin.nl/summary2.htm