Generate automatically name of the sheets

The Worksheet.Name property can be used to change the name of the worksheet in VBA.

This can be either done when creating new sheets, or set afterwards with the Worksheets(x).Name, where x is either the name of the worksheet you want to change, or an index.

For more information you can check the MSDN page about Worksheets.