Macro for new sheet creation and adding cell value to each sheet

[SWSHUBHAM29]

Hello,
Greeting!

I have data of a few codes and corresponding values, like code is "12345" and the corresponding name "abcde".
Now I want a macro where I can create a new worksheet for each code and want to add a name at a particular cell value for a sheet based on the corresponding name.
I have a code for a sheet creation but cannot understand how I can add a name to that sheet.

 

[My Aswer Is This]

Please tell me about your overall objective with specifics.

Do not show me some code you already have and want me to modify it.
I like writing the entire script myself.
When giving specifics please give sheet names like "Alpha" Or "Bravo"
And give column Names like column A or Column B
Do not say column "Data"

If you want to create a lot of sheets give me the name you want to give to each sheet or tell me where I can find the name you want each sheet given.

Look forward to helping you.
Again do not show me some code you already found someplace and then want me to modify the code to fit your needs