How to merge folders files located at different path

how to . Merge these folder’s files by employees name
so that they will be merged according to the sheets