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.
dmaziar@gmail.com