Copy data from closed workbook

Hello:

Please refer to attached sheets.

I need a VB Code to perform following.

Dated data files will be in C:\Temp\ddmmyy_Sales_PLU.xls
Currently i have file : 050115_Sales_PLU.xls

I need to extract data from 050115_Sales_PLU.xls and paste in Book1.xls as shown

Join data from column E and F and put in column A

I have manually pasted as an example.

Please let me know if you have any questions.
Thanks.

Note :

I have tried writing the code as below but it is giving error.

Please Login or Register  to view this content.

Riz