Click the worksheet tab of the sheet you wish to copy, hold down SHIFT, and then drag the chosen sheet along the row of sheet tabs to copy the complete worksheet and all of its data.
