About this tool
Each sheet from each file is added as a sheet in the new workbook, named after the file so you can tell them apart.
Values and formulas are kept. Some special formatting, charts, or macros may not carry over to the new workbook.
This tool combines sheets; it doesn't merge the rows of several tables into a single sheet.