3 Parts- Text File Aggregator, written in Batch. Importing & Data Cleaning in Access, written in Vba. Collecting & Analyzing Prices in Excel, written in Vba. The Office files themselves, and their usage guides, are excluded.
Workflow code is represented as a vba button which merges all Excel sheets in a user-selected folder with the Excel file the button was clicked from. Copy by column instead of range or sheet, columns expected are based on originating file, sheets copied are based on a hard coded list. All constants stored in separate module for easy modification without developer maintenance.