Click the sheet tab to the right of where you want to insert the new sheet.
Click the Insert Worksheet icon at the end of the sheet tabs.
Or click the Home tab. Click the Insert Cells button. Then click Insert Sheet.
A new worksheet is inserted to the left of the selected worksheet.