Sure, use the NewSheet event of the workbook object, as soon as a new sheet is inserted the code will be triggered, since you don't have much information some sort of copying and pasting will probably take place or whatever you set on the code to execute for updating of the master sheet.