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.