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

[arnelgp]

do you have same filename with .xlsx and .xlsm extension?
maybe that is the reason for dups.
modified to add sort to the month.