Summarize cells in another workbook

[streetspeedin]

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
made myself. Each invoice has the total bill amount, billing client
date of bill, etc. in separate cells, and they are located in the sam
cell on each separate invoice. I have these invoices categorized i
folders by my clients.

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

Any way to help me out would be appreciated. Thanks.
(e-mail address removed)