Extraction amounts for each file name based on firs part in file name

[Alaa]

where did you get the month number? there is no date on the excel file.

I mentioned that

4-brings month number in column C based on modified date in column C.

each file contains modified date when show properties inside folders.