I’m attempting to create a macro-based workbook to create digit score sheets. There are five different types. I plan to hide the base templates of each score sheet type (so users don’t use the wrong one), and then, use VBA to copy them. Based on user input, I want a specific number of copies of the scoresheet and then the scoresheets to have names like “Round 1”, “Round 2”,.....”Round n”, where n represents the number of scoresheets the user would enter. I’d like to have it just be one code that I can manipulate depicting on the scoresheet selected rather than five different codes, but whatever is easiest is preferred.

Thanks in advance.