Currently I have a task which require me to transfer (Copy&paste) and update any existing data in the master excel file from multiple excel file in a specific folder by clicking on a button. Currently, I am able to create a code which allow me to transfer (copy&paste) data from multiple excel file in a specific folder to a master excel file, but it will not update any existing data in the master excel file. Could anyone take a look at my code and help me create a code which will transfer and update any existing data in the master excel file from multiple excel file in a specific folder by click on a button ? Much appreciate any help, Thanks. 

**My current code:**

```
Sub LoopThroughDirectory()
Dim MyFile As String
Dim erow
Dim Filepath As String
Dim lr As Long
Filepath = "C:\Users\Joel\Desktop\MultiFileTesting\"
MyFile = Dir(Filepath)
Do While Len(MyFile) > 0
If MyFile = "TestingMaster.xlsm" Then
Exit Sub
End If

Workbooks.Open (Filepath & MyFile)
lastrow = ActiveSheet.Cells(Rows.Count, 1).End(xlUp).Row
lastcolumn = ActiveSheet.Cells(1, Columns.Count).End(xlToLeft).Column
Range(Cells(2, 1), Cells(lastrow, lastcolumn)).Copy
Application.DisplayAlerts = False
'ActiveWorkbook.Close
ThisWorkbook.Activate

erow = Sheet1.Cells(Rows.Count, 1).End(xlUp).Offset(1, 0).Row
ActiveSheet.Paste Destination:=Worksheets("Sheet1").Range(Cells(erow, 1), Cells(erow, 11))

MyFile = Dir
Loop
End Sub

```