Merge multiple sheets data into one worksheet based on multiple criteria and date

As you state correctly, the

Actual format (Custom) will be mmmm-yyyy

but this is something you have done by hand by you worksheets do not have correct date formats in any way.
If I check the cell formats in all the date cells are not formatted as date all are format of the type General which in Excel causes a lot of issues when it comes down to comparing dates and especially if the system settings are different for each user which in my case is dd-mm-yyyyy and since you have NOT set correct format your 03-11-2014 (if you state this is March 11 2014) is interpreted by me as November 3 2014.
This is taking up a lot of my time and I don't think I can help you with these discrepancies and not knowing what is to be filtered.

I have attached three screenshots of the different worksheets and a module you can use to select dates which you should implement

DATA has not format is plain text !

Resubmission ... column C are the dates as displayed here on my system

Statements is you manual modification

I have attached the zipped vba modules you need to import in your file and the code to add to your userforms and the VBA Project Module

'*  global variables
Global g_sDate  As String
Global g_bForm  As Boolean


'* in the Userform use this to select a date 
Private Sub TbxStartDate_Enter()
    g_bForm = True
    frmCalendar.Show_Cal
    Me.TbxStartDate.Value = g_sDate
End Sub

Private Sub TbxEndDate_Enter()
    g_bForm = True
    frmCalendar.Show_Cal
    Me.TbxEndDate.Value = g_sDate
End Sub

The red marked code code you place in Module1, the other part in the USerform1 and give it the name of the textboxes you use for the date

I hope you can make it work.