Compiling Data from Multiple Stardardized Excel Files into ONE Excel Master File

Hi There,

I have a few hundreds of Excel files that contain data collected from users that I need to compile/combine in one separate excel file for analysis. Some of the data is in column format and all contained in one sheet. I use Excel 2010 and have very limited knowledge of Macros or Visual basic. Attached is a copy of the sample file containing the data that needs to be imported into the master file. The exact cells that need to be collected are as follows:

Column C/D (merged) - Row 11 to 19
Column E - Rows 22 to 63 (please note that the rows are merged, so each group of three consecutive rows actually contain on data item in column E)

The cells to be collected are all colored in Yellow in the excel file attached.

The compiled master file needs to have one row for each excel file containing the date. All Identification information for students and instructors should come first, followed by the student score. (i.e. one row per excel file collected).

Please let me know if I need to provide anything else.

I would greatly appreciate it if someone can guide me on how to create the desired master file.

Regards,
-Ammr