How to create a master sheet so that all other copies do the exact changes made to the master?

[Jaijames]

So I'm making a range of scorecards for different suppliers. I have the basic format down on a master sheet but will be making some changes in the future. I have made a master sheet and copy and used =Master!E10 for example, to copy the contents over so if I make any changes to a cell then all copies will follow suit.

However, this doesn't cover formatting and any addition of new lines, scores, a change in my table etc. I need multiple sheets that copy everything such as making a row bigger for example.

I also have a list of 200 suppliers, how would I make a duplicate sheet named for each supplier and put some of their info into certain fields?

 

[My Aswer Is This]

We can right a script like this which makes a copy of the Master sheet.
Now this may not meet all your needs but it's a start.
Now this is just a sample the final script will check for sheet names and make sure there is not a similar sheet name.

Sub Copy_Master_Sheet()
'Modified 10/1/2021  12:56:32 PM  EDT
Application.ScreenUpdating = False
Dim ans As String
ans = Range("A1").Value
Sheets("Master").Copy After:=Sheets(Sheets.Count): ActiveSheet.Name = ans
Application.ScreenUpdating = True
End Sub