Macro to filter data base on combobox value

[SSF1590]

Hello,

Would it be possible to have your help to change the below macro so it filters the data I have in worksheet "Data" in worksheet "DataFilter" based on combobox5 "Open", "Closed", "All". These three criteria are in column M in row 27 i my worksheet data.

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$B$2" Then
If Range("B2") = "All" Then
Range("A5").AutoFilter
Else
Range("A8").AutoFilter Field:=2, Criteria1:=Range("B2")
End If
End If
End Sub

Thank you.