I guess my question is how do named ranges work on multiple sheet templates?

Does a named range depend on the name of the template that it is in. I have three sepearte templates that I want to combine into one template.

When I try and insert the combined template into a worksheet, even when I rename the sheets, I get an error saying there is already a range with that name in the worksheet.

But if I were to insert each worksheet individually each time I wanted to insert another set of 3, as long as I rename each one it works fine.

I do not understand why the combined template does not function properly.