Sheets Object (Excel)
A collection of all the sheets in the specified or active workbook.
Use the Sheets property to return the Sheets collection. The following example prints all sheets in the active workbook.
Use the Add method to create a new sheet and add it to the collection. The following example adds two chart sheets to the active workbook, placing them after sheet two in the workbook.
Use Sheets(index), where index is the sheet name or index number, to return a single Chart or Worksheet object. The following example activates the sheet named "sheet1."
Use Sheets(array) to specify more than one sheet. The following example moves the sheets named "Sheet4" and "Sheet5" to the beginning of the workbook.