linking 9 workbooks

[Guest]

Hello, I am trying to link 9 workbooks that contain about 350 clients and 9
columns of data, all 9 workbooks are formated the same way but contain
diferent values, I need to consolidate all the books into a master monthly
total sheet that will reflect any activity in any of the 9 workbooks.

example: wb1.xls(montly totals)+wb2.xls(montlhy totals)+wb3.xls......and so
on to be added into a MASTER sheet


Thanks in advance for any help that you can provide.

 

[Guest]

I think you should look at this:
http://www.rondebruin.nl/copy2.htm
(one of my favorite sites on the web)

Once everything is in a summary sheet, create a Pivot Table.
http://peltiertech.com/Excel/Pivots/pivottables.htm
http://www.contextures.com/xlPivot07.html#Unique
(two more GREAT sites)

Regards,
Ryan---