Copy data from closed workbook to open workbook

Hello Seniors,
I want to write a vba that will copy some cell ranges B5 to B1000 and F5 to F1000 from Report B (closed excelsheet) which is in local disk and then paste the copied cells in Report A range D5 to D1000 and E5 to E1000 respectively (open excelsheet). I want to achieve this when I press a button in Report A and save it. I am novice to excel and I know that this is an easy problem.
Waiting for your expert help.

Amandeep

To explain it better I have attached two excel sheets namely Report A and Report B. I want to copy data from report B to report A. From report B I have to copy column B and column F to column D and column E of report A respectively. I have a copy button in Report A which should do the copy. Now I will open my Report A and press copy, then my code should open Report B which is in local drive, copy data from it and close Report B and paste it to A which should be kept open. In other words report B is closed when I press copy button and after finishing the copy paste the code should again close B and save Report A and Report B.
Need expert help on this.

Amandeep