Question: how to convert multiple excel sheets into one?
Answer: With the master workbook open, go to the Ablebits Data tab > Merge group, and click Copy Sheets > Selected Sheets to one Workbook.
In the Copy Worksheets dialog window, select the files (and optionally worksheets) you want to merge and click Next.