VBA to copy Text in a cell to another sheet if the adjacent cell matches the Sheet name

[amstall]

I manually enter the values in columns C and D on the "Master" worksheet. I then have a macro with button built to automatically copy the "Template" worksheet and rename it the value in column C from the master. This also copies the formula in cell B9 from the template to each sheet, which just copies the sheet name. =MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255)

I want to piggyback off my original macro w/ button in infill the values in B9 and C9 on the created worksheets from the list on the Master worksheet columns C and D, if the sheetname matches with column C.