An open-source TypeScript project for Microsoft Excel 365 that extracts data from sheets with similar naming patterns and outputs the results to a new sheet.

This project is licensed under the MIT License.

R4WD4WG, 05/01/2023

• Look for sheets with similar naming patterns
• Perform lookups for corresponding values
• Output results to a new sheet

1. Save the Office Script file to: Documents/Office Scripts (create the folder if it doesn't exist).
2. Launch Microsoft Excel 365.
3. Open the "Automate" ribbon at the top.
4. Click "New Script" on the left side of the ribbon.
5. The script should appear. If not, copy & paste the content into a new script within Excel.

Customize cell references, sheet names, etc., to fit your needs. The script can scale to any size depending on computing power.