Worksheets(1)
is the first (leftmost) worksheet in the workbook, and Worksheets(Worksheets.Count)
is the last one. All worksheets are included in the index count, even if they are hidden.You can move or copy a worksheet in the same workbook to organize your workbook exactly how you want.
You can always ask an expert in the Excel Tech Community, get support in the Answers community, or suggest a new feature or improvement on Excel User Voice.