Writing a VBA macro for processing multiple files

There are several files in the folder (2-10).
The first of these files (for example with the name ved301) is a list of the main group of students, with assessments (released according to the formula)
The remaining are the lists of couples, from which the main list is composed.

The macro is required, which at the start of the main file, finds the selected in the basic list of names (or list of names) in the subgroup and subgroup files (if found), near the corresponding name, the range of cells, which corresponds to this name.
It is also desirable to notify the corresponding names.