Creating multiple worksheets from one worksheet

Hello all,

I have a template worksheet with vba codes assigned to it.

What I need is:

I need a button in the template sheet as "Copy".
When clicking the button it should prompt me a InputBox.
So that the value I enter should become the name of the sheet created.

Will I get a worksheet with vba codes assigned to it or only the Worksheet with formulas?

File attached. Kindly consider the template worksheet.

Kinldy please help me out.

Thanks in advance excel gurus.