Does anyone know of any third party products that can collate information from multiple Excel files and produce a report?

The Excel files will all have the same format, multiple sheets, and the data to be collated could come from one or several of the sheets.

The files will be stored in a folder/sub-folder structure, the depth of which could depend on the end user.

Files may need to be included/excluded depending on the file name and/or file/cell content.

I have written a reporting tool to do this but I'm looking to see if there is a purpose built application that may do it better, or more quickly, or more efficiently, or with more flexibility, or all of the above.

Any thoughts or suggestions would be appreciated.

Thanks, TMS