Retrieve Info On How Many Files There Are Named XX In A Folder

I have several excel files in a folder, and they are named:

AA v.5
AA v.6
AA v.7
AA v.8
BB v.5
BB v.7
CC v.8
CC v.6

The "AA" and "BB" are names of who created it and v.5 are the week it was created.

What I would like to do is in an Excel file be able to choose to retrieve information about for example how man files with v.5 in its name.

OR information about all files with "BB v." in its name (to see all files created bye BB)

Or "BB v.4" (all files created bye BB in week 4)
Or "BB v.4"+"BB v.5"+"CC v.6"

The reason for this is that I would like to be able to create statistics from this so that I can see how it has changed like in a graph. So that I can see the difference and compare how many files BB and CC have created and which week.