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