Filtering based on partial filename

[jordanburch]

Hey all I have the below code

ActiveSheet.Range("$A$1:$AF$100000").AutoFilter Field:=21, Criteria1:= _
        "=CO21army" & Left(ThisWorkbook.Worksheets("Variables").Range("a8").Value, 3) & Right(ThisWorkbook.Worksheets("Variables").Range("A3").Value, 2) & ".xlsx"

Is it possible to simply filter on just the CO21army & the Left(ThisWorkbook.Worksheets("Variables").Range("a8").Value, 3) part? something I would imagine looking like this

"=CO21army" & Left(ThisWorkbook.Worksheets("Variables").Range("a8").Value, 3)* &".xlsx"

any help is appreciated!

Jordan