Get data from multiple excel file into one excel worksheet

Dear all,

I have about 300 excel files with school activities data input by other teachers. I want to combine those data into one excel worksheet to make summary and statistic.
so, there are two task,
1. combine data from multiple excel file into one(solved already)
2. combine only certain cells' content from multiple excel files into one excel worksheet's designated cells

Wish someone can solve it and

wish you all Happy New Year!

beginner of xls
Mr. Lam