Get other workbook names matching cell values from main workbook

[rcmistri]

I have file (e.g. MainList.xlsm) having list of names (in column C) and other excel files (e.g. AreaList_1.xlsx, AreaList_2.xlsx, AreaList_3.xlsx . . . AreaList_n.xlsx) which also have names in column C and some other details (many or all names may not be in MainList.xlsm). I want to find out which AreaList_x.xlsx file(s) have matching names from MainList.xlsm file. This finding can be listed against each names in MainList file column D. below are the structure of files :
MainList.xlsm

Sr No.	Area	Name	Files Matching (expected with VBA)	other details . . .
1	Area1	Name1	AreaList_1 AreaList_3 (file extension is not a problem if added with file names)	details1
2	Area2	Name2	none	details2
3	Area3	Name3	AreaList3	details3
4	Area4	Name4	AreaList_7 AreaList_10 AreaList_16 AreaList_22	details4

AreaList_n.xlsx (Names column may have different names or few matching names in some of the files)

Sr No.	Area	Name	other details . . .
1	Area1	Name3	details3
2	AreaX	Name22	details22
3	AreaN	Name46	details46
4	AreaA	Name4	details4
5	AreaD	Name1	details1
6	AreaC	Name78	details78
7	AreaF	Name34	details34

Note :
1) All files will be in same folder
2) names may be added or removed from Name column in MainList.xlsm file

I am totally new to VBA but but not new in programing, I have done some coding in Python, JS and ASM (microcontrollers) languages and have been using excel and built-in functions since many years (without vba macros).
Can someone have idea on this ?