Automatically export a selection of individual worksheet into a master sheet

Hello all,
I have say 20 employees with their own individual excel workbook to enter data into. This file is saved on our server sharepoint in a specific location.
I only want a portion of their spreadsheet to automatically upload into my master spreadsheet also on our server into a specific area on the master sheet.
To be specific:
For my first employee, I would like the data from the individual sheet B3 to F42 to upload into the Master sheet B3 to F42.
Then for the next employee I would like the data from the individual sheet B3 to F42 to go to the Master Sheet G3 to K42
and so on for all 20 employees.
The Master File is called "DSP_DCM_Mastersheet"
I'll include a picture of the individual and Masterfile.

This is about as far as I've gotten and I don't even know if putting "My File" is right or if I should use the employee's file name.

Sub LoopThroughDirectory()
Dim My File As String
Dim erow
MyFile = Dir("Where the sharepoint folder is")

Do While Len (My File) > 0
If MyFile = "DSP_DCM_Mastersheet.xlsm" Then
Exit Sub
End If

Workbooks.Open (MyFile)
Range ("B3:F42").Copy
Active Workbook.Close
Master Sheet.PNG
Individual File.PNG

Wow, thank you. This might do it. I'm trying but
I am hitting a minor snag though in where to place the file and folder names if that is applicable.
Here is what I have:
1. The individual excel files say "Employee 1" "Employee 2" and these are stored in a sharepoint folder named "DSP DCM Individual Files" and the folder location is lets say "\\sharepoint.sharepoint.com\ws\Documents\Admin\Capacity Management"
2. Then there is the master sheet named "DSP DCM Mastersheet" located in a folder named "DSP DCM Mastersheet" and in the sharepoint location of "\\sharepoint.sharepoint.com\ws\Documents\Admin\Capacity Management\DSP DCM Mastersheet"

I have tried plugging in some of this information but it doesn't seem to be linking. Maybe I'm putting in too much?

Thank you very much for your help