Conditioned combination of several workbooks to one Master workbook

[MSconfusedX]

I have 8 workbooks of different teachers, each workbook has 5 sheets for every student, total of 40 sheets. Not every sheet has students information.

Now, I want to combine the worksheets of different workbooks into one Master Workbook, however; I want to only copy those sheets which have student information, to be more clear only to copy those sheets when cell C4 has a string value and not empty
**Cell C4 contains the name of the student, and if it's empty then the worksheet doesn't have any infos, hence should not be copied.

I know it's possible in Macros, but i have a very limited knowledge of it, hence can't produce a working VBA code.

Notes:

• All the folders are in the same directory.
  
• If it's going to be hard to add only the worksheets of the student information, then let it be all the worksheets of all the workbooks, for now.
  
• I want the workbook to update the worksheets every time it is opened, or maybe add an update data button.

I would appreciate immediate help ... THANK YOU