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