Populate drop down box from active dates

[excelsiors]

Hello all,

I posted a similar request before but think I over complicated it and scared people off

I'm trying to populate a drop down list with months (Cell A3 in 'Report' sheet) from a list of dates that is to be updated regularly, and not a predefined list.

The dates are to be displayed in the format of 'Jun-14' and taken from information in the 'Programmed Date' column on the 'Tracker' sheet.

Future dates will be added to the 'Programmed Date' column on a regular basis. Many will be in the same month and year, some will include months not already included and I would like the drop down box to reflect the newly added months as options.

Many dates will also be from the same month e.g. 20/05/2014 & 30/05/2014 however I do not want duplicates of the same month, in this case 'May-14'.

Hope someone will be able to provide a solution

Thanks