Question: how to transfer data from multiple worksheets into one?
Answer: Start the Copy Sheets Wizard. On the Excel ribbon, go to the Ablebits tab, Merge group, click Copy Sheets, and choose one of the following options: ... 
Select worksheets and, optionally, ranges to merge. ... 
Choose how to merge sheets.