Generate worksheets from list of values and have each worksheet contain the same formula

Greetings,

I have a macro that creates worksheets based on the values in column A; 1 tab for each value with that value as the tabs name.

The next step, where I'm completely lost, is to have each of these new tabs be a copy of the "tab setup" worksheet with the value in cell B1 matching the tab name.

I've attached a workbook to help explain my desired outcome, any and all assistance is greatly appreciated.

tab setup for excel forum.xlsm


Current code is shown below:

Please Login or Register  to view this content.

Why not copy the 'tab setup' sheet?

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Thank you all! I'm running through each but they all appear to do exactly what I want.