Require help in modifying the code to copy data to an existing file instead of new file

Can anyone please help me to modify the code to paste the data to an already existing file...
1. This line of code creates a new file and pastes the data.

Please Login or Register  to view this content.

Instead I wanted to give the path to an existing file, and the sheet and cell range where it can be pasted, the file has to be opened and pasted to the dest ranges

2. This part of the code actually does the selection of the ranges to be copied, and pastes to the dest file from cell A1.

Please Login or Register  to view this content.

Instead I want to define a maping. For eg:
A1:A10 to be copied and pasted in C1:C10 of the destined sheet
C1:C10 to be copied and pasted in A1:A10 of the destined sheet
E1:E10 to be copied and pasted in B1:B10 of the destined sheet

Here is the entire code... your help is much appreciated. thank you in advance! I am not able to attach the sheet for some reason
you can copy this code and paste it to the source workbook/sheet where you want the data to be copied from.

Please Login or Register  to view this content.