Excel macro to autofill a list and create new worksheets with names from the list

Hi,

I'm working on a side project to create an engineering tolerance stack template on excel and I was thinking about using Macros to automate majority of the process.

My company already has a template that exists, but to replicate this template on additional new worksheets I'd have to copy, paste and rename it manually.

I have managed to record a macro that copies the template and paste it on a new worksheet, but I am unable to rename it to a sequential name (eg. Risk 1, Risk 2, Risk 3...)

I also tried recording a macro that autofills from a list and tried renaming it from the cell range but I can't add new lines of autofill each time I start the macro.

Can anyone provide some advice on how I should approach this? I have a feeling my concept for the macro has a few fundamental errors and there is a much simpler way to do it.

I've included the actual template that I am working on in the attachment for reference.

(P.S. I'm not excel VBA trained, I found what was available online and tweaked a little bit here and there, so I apologise in advance if I sound like I know nothing because that is probably true)

Thanks Guys!