Copying data on Macro Enabled Excel Sheet from Source File

Registration date
Wednesday November 20, 2013
Last seen
November 20, 2013
I am doing account reconciliation on a Macro enabled excel sheet for various funds.

which performs some task through Macro on sheet, Now i want to add one more

automated task in it.

At the end of month I receives expenses ...

from source in excel file for various funds (nearly 50) Now I want to copy those expenses

in to reconciliation file in below mentioned format from source file through Macro

Date Ageing Custody Amt Acctg Amt Difference Code Explanation

Auto Auto From Source file (0.00) Auto from Source file