Question: how to copy and create multiple sheets in excel?
Answer: Make sure your single worksheet is selected.
Right-click the worksheet tab. ... 
Choose Move or Copy from the Context menu. ... 
Select the (move to end) option.
Make sure the Create a Copy check box is selected.
Click on OK.