Question: how to copy data from multiple sheets to one sheet in excel 2016?
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.