My goal is to be able to pull and present data from several individual excel workbooks, either at once or at least one-by-one. Would this be a reasonable task for a macro? Example: there are 5 or 6 excel workbooks, and each has a worksheet named "Chevrolet." Each Chevy worksheet runs calculations, and presents several result numbers in various cells (like perhaps dollar amounts). Those result cells will always be in a particular column, say column "M", but the row number might differ from woksheet to worksheet. The row of interest would always have some sort of consistent marker, i.e. "corvette" and "insurance."

Can a macro be created which goes to 5 different excel workbooks, finds the Chevy worksheet, finds the corvette - insurace row, goes to column "M" and pulls back the dollar amount, so that a summary spreadsheet can show the 5 different dollar totals for Chevy/corvette/insurance?

Basically, I'd like to know if it is worthwhile to pursue learning macros to write something like this. Please tell me if it won't work or will be too cumbersome/fragile... we currently do something analagous manually. It is not hard to do, but the a pain each time the data changes. It would be easier to just know a document version has changed, and let the macros pull back the new numbers.

Thanks to all who respond with their suggestions/opinions!

D