Add Multiple Sheets to a Workbook at Once Using VBA
Go to http://www.Teachmsoffice.com to view all of this tutorial.
This Excel VBA macro tutorial shows you how to add multiple worksheets, sheets, tabs, etc. to a workbook using a macro. This method does not use a loop and so is very easy to use and understand. As well, you will learn how to insert the new sheets before or after other sheets within the workbook.