Question: how to combine multiple excel files into one workbook using macro?
Answer: Press Alt + F8 to open the Macro dialog.
Under Macro name, select MergeExcelFiles and click Run.
The standard explorer window will open, you select one or more workbooks you want to combine, and click Open.