BUY EXCEL BOOKS ONLINE: 1. VBA & Macros      2. VBA for Modelers      3. Excel 2013 VBA and Macros     
4. Excel VBA for Dummies      5. Excel with VBA & .NET      6. Mastering VBA      7. Excel 2013 Programming

Insert 'n' number of worksheets in Active workbook


Sub InsertBlankSheets()
    On Error Resume Next

    Dim N As Integer
    N = InputBox("Please enter the number of Blank Sheets to be inserted.", "Insert Worksheet(s)", 1)
    For i = 1 To N
'Sheets.count returns the number of sheets present in the workbook
'So every sheet will be added after the last sheet
        ActiveWorkbook.Sheets.Add after:=Sheets(Sheets.Count)

    On Error GoTo 0
End Sub

Note: If you want to add sheets before the first sheet, change the line inside For Loop to following:
        ActiveWorkbook.Sheets.Add before:=Sheets(1)