I have a workbook with many sheets labelled in the format Mmm YYYY (ie Jan 2013, Feb 2015 etc)

I have a combobox that i populates the Year of Account by way of 

With ComboBox2
.AddItem "2012"
.AddItem "2013"
.AddItem "2014"
.AddItem "2015"
End With
Instead what i would like is to have code that gets round this "fixed" way of working, and populates the combobox with the years of account that exist in my list of worksheets.

is that possible?

the list of sheetnames in question are
Jan 2013
Feb 2013
Mar 2013
Apr 2013
May 2013
Jun 2013
Jul 2013
Aug 2013
Sep 2013
Oct 2013
Nov 2013
Dec 2013
Jan 2014
Feb 2014
Mar 2014
Apr 2014
May 2014
Jun 2014
Jul 2014
Aug 2014
Sep 2014
Oct 2014
Nov 2014
Dec 2014
Jan 2015
Feb 2015
Mar 2015
Apr 2015
May 2015
Jun 2015
Jul 2015
Aug 2015
Sep 2015
Oct 2015
Nov 2015
Dec 2015

so i would expect the combobox to populate with 2013, 2014 and 2015.

Nick