Copy and name worksheet as 12 months

[VbaHell]

Hello all

I am trying to use VBA to look at value "C4" on the active sheet
Then copy this sheet 12 times and rename each sheet and based on "C4" as the 12 months from the value of "C4" on the active sheet

IE

Active sheet value in "C4" = Dec 17

Jan 18
Feb 18
Mar 18

and so on for 12 month but also renaming "C4" as the same as the workbook

Can anyone help on this please

 

[Joe4]

What have you got so far? Can you post the code that you have?

Note that you should be able to get the code for inserting a new sheet and copying the sheet by using the Macro Recorder.
Then, it is just a matter of wrapping it in a loop and incrementing the date.
Is your entry in C4 an actual date entry, or a Text entry?