Instead of trying to create separate code for each new sheet with the Visual Basic extension (see this link for further reading), just use the Workbook broadcast event Workbook_SheetChange(you need to put it in the module ThisWorkbook).
In this case, first check the code if the worksheet that raised the event is one of the newly created worksheets. This can be done most easily by checking the .Nameworksheet.