While Power Query is a fantastic option for transforming ... macro workbook serves as a centralized repository for storing VBA code that you want to use across all Excel workbooks.