There's a shortcut!
Hold Ctrl down, then click and drag the sheet tab. Release the mouse button first when the little arrowhead indicator is where you want your copied sheet to go. This creates a copy of your sheet with the original name appended with a number in brackets.
Keep Up with TechRepublic