Question: how to convert multiple excel tabs into one?
Answer: Copy sheets in each workbook to one sheet and put the resulting sheets to one workbook. Merge the identically named sheets to one. Copy the selected sheets to one workbook.