Question: how to copy to multiple sheets in excel?
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.