Selecting and Copying a Cell or a Range of Cells from One or More Files or Worksheets

Will the returned workbooks be saved into one directory?

It's going to be placed in the same folder.

Here's an example of I meant to say:

The "Consolidation_File_Grades.xls" file is supposed to contain the data from the individual files and/or worksheets. Yellow cell color refers to the data which was taken from individual files and/or worksheets.

The "Grades_Adams&Santos.xls" and "Grades_Moreno&Toledo.xls" files are two sample files of the 250 persons when the give me back the template or form (still an excel file).

Data from these two (or infinitely more files) will be taken at certain cells. In this scenario, they are B1 to B4 and D8. These two files and all files which will be placed in this same folder will have the same format and text, except that of the indicated cells (B1 to B4 and D8).

The question is how do I go about this? Do I need to create a macro? ...Or is there a function in Excel that can do that for me?

I saw a code which I think is very much related to this topic. I just don't know how to read code yet nor how to make some.

I copied this from this website (forgive me for not mentioning the author). It shows partially how to do it. The problem is that this code only applies to a single file and it only lists the copied cells to one row:

'The following will return the values on a sheet in a closed workbook and write them to the same range on the active worksheet. Place the code below into the standard module

Sub test()
GetValuesFromAClosedWorkbook "C:", "Book1.xls", _
"Sheet1", "A1:K30"
End Sub

Sub GetValuesFromAClosedWorkbook(fPath As String, _
fName As String, sName, cellRange As String)
With ActiveSheet.Range(cellRange)
.FormulaArray = "='" & fPath & "\[" & fName & "]" _
& sName & "'!" & cellRange
.Value = .Value
End With
End Sub

Thanks in advance,
Tyler