I am having data on multiple workbook ( Source 1.xlsx, Source 2.xlsx, Source 3.xlsx, Source 4.xlsx, Source 5.xlsx). I want copy that datas's to Destination.xlsm sheet1.
For example, Source 1.xlsx Sheet "20" data's are entered up to Feb-20 month and that is copied to Destination.xlsm sheet1. If I add data's on Mar-20 (Column G) on Source 1.xlsx, when i click the copy data button it should copy the Mar-20 value only and update on Destination.xlsm (Column G) . It should not copy and overwrite the previous month values.
You can refer the Sample.xlsx file for how the values to update on Destination.xlsm file.
I attached all my files here for your reference.
Kindly do the need full for this