An index number is a sequential number assigned to a sheet, based on the position of its sheet tab (counting from the left) among sheets of the same type. The following procedure uses the Worksheets
property to activate worksheet one in the active workbook.
If you want to work with all types of sheets (worksheets, charts, modules, and dialog sheets), use the Sheets
property. The following procedure activates sheet four in the workbook.
The index order can change if you move, add, or delete sheets.