Need help to extract data from multiple file with no fixed format

[hello123]

Hello, I have a master file with headings in row 1. In another folder and its sub folders there are multiple excel files and the headings are in different columns instead of rows and their values are in in next column i.e. a heading like "Name of student" may be in cell B5 then its value will be in next column cell C5. Similarly in another excel file the same heading "name of student" might be in cell B10 then its value will be in cell C10.
I want my master file to get updated by searching all the files with the headings present in master file's row 1. Any help will be much appreciated. I am using Office 2010. I cannot use power query due to some restrictions.

 

[vletm]

hello123
Upload a good sample file with needed results,
all needed information of Your folders and
all needed files.

 

[hello123]

I have attached a sample Master file which needs to be updated from the files stored at location "K:\Office docs\Stu\Database\New" and its subfolders which keep on adding. I have also uploaded 2 sample files from which the master file needs to be updated.

 

[vletm]

hello123
Is there clear logic with subfolders/-names and filenames?
Which information need to be different that it would need to update?
... eg if [Last grade] is different than in 'Master file', is it NEW or do update?

 

[hello123]

1. There is no logic with subfolders, names and filenames. Anyone creates a subfolder and saves files with any name they desire but the main folder is "K:\Office docs\Stu\Database\New" and subfolders and files are saved under this only.
2. From each file the master file needs to be updated. Each row in master file should get updated with information in each file. e.g. for files attached the master file should give the below output:
S. No.Name of studentClassClass teacherDate of birthLast grade
1qeqe7deggg2/8/1990B
2xyz5dasdasd4/5/1988B

 

[vletm]

hello123
1) ... then I could only help if You're using Mac.
Otherwise, it would be better to get clear logic for those folders and filenames.
2) as I tried to ask, how to know which makes NEW row?
or when update to 'old' row?

 

[hello123]

1. I will place all files in the same folder "K:\Office docs\Stu\Database\New". Filenames I can prefix each file by "indiv" and extn will be xlsx
2. All files make new row in the Master file

 

[vletm]

hello123
Save this file to "K:\Office docs\Stu\Database\".
New-folder ... actually it would need to be new (if challenges)
All extracting-files which has extn .xlsx would try to add to end of Master File.
>> Press that [ Do It ]-btn to start <<

 

[hello123]

This is exactly what I wanted. Couldn't have imagined such a wonderful solution.

Great work!