Using Excel
Create summary from (wine) order sheets
Links
Get list of Excel files in a folder using VBA
VBA INSTR – Find Text in a String
Excel Macros Tutorial: How to Create a Simple Macro
VBA Express: Excel - Get File Names from folder