Creating a new sheet with each new line item

I have a workbook that has a template for blanks and a template for coils. I have a table of contents page which is where the data entry begins. What I would like is to make an entry on the table of contents page. In this case, starting with row 4. I would put coil or blank in a column. This would determine which template to use. The next column is for safety. If the answer is Yes, I would like to add the note shown on the Example sheet in cell H1. The next column is for the part number. I would like for the part number to automatically go into cell C3 and then have the new sheet be named whatever is in c3. There has to be a new sheet for every part number using either the coil or blank template. The sheet needs to be named by the part number and safety critical items need to be identified on the sheet. The goal is for all of this to happen automatically when adding a new line on the table of contents page. Thanks!

I tried copying the code and I got an error message.

Capture.JPG

I hadn't been able to open the file and run the one that you sent, but I was able to finally do that. It works! Thank you. I was wondering though, and maybe this is too much, but if it could also change the cell on the template for part number C3 to the new part number - the same one as the tab is named as. Maybe that's too much. I don't know, but is it possible to add that layer?

Thank you so much for your help! But now, I have one more additional question...
Is there a way to add the safety critical note after the fact. For example, If someone adds the line on the table of contents page, but then doesn't put the yes or no in the safety critical column right at the beginning, but then goes back to that later and puts "yes" for safety critical, is it possible to have the note show up on the tab that had been created already? One of my work colleagues is asking the question as I was super happy with it. If it is not possible, then that will just have to be a manual entry. Just figured I'd ask.

Again, thank you so much for the help you've given so far!

It works great as originally requested, but it won't add the safety critical after the fact. If you skip that column, create the new sheet, then go back and choose "Yes" to safety critical, it won't add the safety critical statement. It only works if you choose it before creating the sheet.

Forgive me for my ignorance... where in the code to I add the additional code? Does it go at the end of the code you already gave or does it go somewhere in the middle of it?

Thank you so much for the time you have given on this!