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