Import data from closed workbook

Hello:

Please refer to attached sample files.
I have attached Master file and 2 data file.
In master file Sheet1 (open file), i will be choosing the file name (closed file) to export the data to sheet2 of Master file.
Below is what i need the VB Code for:
Will have weekly data file in C:\Test2\ directory and name of the file would be in cell Shee1 of Master file Cell A2.
I need the data from Book1, Sheet1 data in column AM,AN and AJ to be pasted in the next available row in Sheet2 of Master file in
column A,B and E.

Let me know if you have any questions.
Thanks.

Riz