property WorkSheets: IXLSWorksheets;

This example creates a new worksheet and then places a list of the active workbook's sheet names in the first column.

Sheet := Workbook.Add;
for i := 1 to Workbook.Worksheets.Count do
   Sheet.Cells.Item[i, 1].Value := Workbook.Worksheets[i].Name;