Summarize cells in another workbook
 

Not sure how to search for this feature, or if such a feature exists :

I do billing for my trucking company in Excel with a template that I
made myself. Each invoice has the total bill amount, billing client,
date of bill, etc. in separate cells, and they are located in the same
cell on each separate invoice. I have these invoices categorized in
folders by my clients.

I am looking for a way to extract and display the values of the bill
amount, date, and client name, etc. from a large number of other
spreadsheets into one spreadsheet. Is there a function or program that
can check and summarize a specific cell in a range of worksheets in a
certain folder?

Any way to help me out would be appreciated. Thanks.



--
streetspeedin
------------------------------------------------------------------------
streetspeedin's Profile: http://www.excelforum.com/member.php...o&userid=33511
View this thread: http://www.excelforum.com/showthread...hreadid=533042