Merging or Consolidating Data from Multiple Workbooks
 

I have been given the project of setting up one consolidated or merged report
using the data provided from our satellite offices monthly figure
reports/workbooks. There are five satellite offices. Each workbook, which
is received via email, is identical in their setup, formulas. The only thing
that changes is the information for the next month. How can I establish one
excel worksheet reflective of all the information from each workbook but
allow it to "update" with next month's information? Note: Each workbook
contains an office total tab and then individual team tabs which of course
rollup into the office tab.


--
EvieB