CONCRETE EXAMPLE
6 workbooks → 1 XLSX
BEFORE
→18 sheets spread across 6 files
AFTER
1 workbook with 18 uniquely named sheets + cross-sheet reference report