Macro to Add New Sheet with a New Year in every Sheet

[nico2pacnwa]

Hey guys,

I am new to VBA and I am climbing the ladder by working on simple projects.

Currently I am working on a calendar, it has a button "Add New Cal", when clicked it duplicates the active sheet but only changes the year; i.e. The active sheet has a calendar year 2016 and is a named range "Year", when duplicated the year changes to 2017.

I suppose this is a very simple code....but I am not there yet with VBA

Thanks