Question: how to copy multiple sheets in excel to new sheet?
Answer: Click on any of the selected tabs, press Ctrl and drag the tabs to the desired position.
Right-click any of the selected sheets and click Copy or Move. Then, carry out these steps.
On the Home tab, click Format > Move or Copy Sheet. More details can be found here.