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