Question: how to copy multiple sheets in excel to same workbook?
Answer: In the certain workbook where you will copy worksheets, select multiple worksheets on the Sheet Tab bar. ... 
Right click the selected sheet tab on the Sheet Tab bar, and select Move or Copy from the context menu.