With Ablebits.com Consolidate Worksheets Wizard you can easily combine multiple worksheets into one or merge several workbooks and csv files without opening them.
Downloads: 75249 - Shareware - Download Now

MAPILab Find and Replace for Excel is an advanced version of the "Find and Replace" function. The add-on has a number of benefits: simultaneous work with several files; saving and downloading retrieval requests as templates for reuse and other.
Downloads: 86518 - Shareware - Download Now

Use this application to find and extract all URLs in your Excel files. Save the results to a text file. You must have Excel installed on your machine.
Downloads: 76982 - Shareware - Download Now

Combine data in many OpenOffice Calc files into one sheet or individual sheets per file. Calc 2.0 or higher required.
Downloads: 74214 - Shareware - Download Now

Import one or many Excel files into a blank MS Excel file. Specify local Excel files and either insert them all into one sheet or individual sheets per file. Excel 2000 or higher required.
Downloads: 110443 - Shareware - Download Now