Can mulitple Excel workbooks be summarized into 1 workbook?

[micjil]

I have multiple Excel workbooks and need to extract the data from certain
cells in order to sum the cells into a summary workbook. Can this be done?

 

[Luke M]

Probably. Take a look at Ron's site:
http://www.rondebruin.nl/tips.htm

specifically, his article on "Merging Data from Multiple Workbooks"
http://msdn.microsoft.com/en-us/library/cc837974.aspx