Macro to create a sheet and paste that sheets name in a specific cell

Hello everyone,

I currently have a macro that creates copies of a template sheet based on the information put in column B on my main tab, so if I have four cells in column B with data, it creates four tabs all named with the information in each of those cells. The problem I'm facing is that I need that name to also be in a cell on the tab and I'm not sure how to do this with a macro. I have a formula that does it but with large clients I end up with a ton of formulas connected to this one formula, which is volatile, and the spreadsheet gets very slow since every formula has to recalculate. So what I need is either:
1: add a line to my macro (below) that also takes the name it gives to the tab and puts it in a cell as well, or
2: a second macro that will take that formula that is pulling the sheet name, which will be in the same spot on each visible sheet, copy it, and paste as value in another cell on the same sheet, which I could then have my formulas linked to.

Any help would be appreciated.

Here is my macro to create and name the sheets.

Please Login or Register  to view this content.

Hi Jhoov326,

If I understand correctly, you want the name of the new sheet placed in a cell on that new sheet?

Please Login or Register  to view this content.

Presumably

Please Login or Register  to view this content.

Glad we could help