Adding Worksheets
There is an Excel file that teaches how to perform the Adding Worksheets operation.
Excel Template for Adding Worksheets
This workbook adds new worksheets to a workbook dynamically using VBA, starting from a three-sheet base structure.
Hope it is useful.