Excel Report from multiple excel files

I am in a difficult situation now. I have 3 Excel files named X, Y, Z. Excel file named X is created from a application and files named Y is the final report file which provided by customer. I need to input some data from file X,Z into Y.

"QRN 275 & 276 " from this file I need to capture data and import it into this file "QSR.FC012-BIDIR iOLM Test Results v1.1_20161101".

"QRN 275 & 276 " this is just one of the file and I have many such files which has to capture data to "QSR.FC012-BIDIR iOLM Test Results v1.1_20161101".

"QSR.FC012-BIDIR iOLM Test Results v1.1_20161101". This is the final report file. Content has to be updated in this report.

At present I am doing the copy paste and it is taking too much time to complete the task. The file Y is same for all the different X files which I am receiving from customer on daily basis.

Any help is very much appreciated

Thanks in advance for the help.