I am trying to consolidate information from Sheet1(supplier) to master Sheet1 and Sheet2(supplier) to MasterSheet2 : Friends ,need Some Help on VBA(Macros for excel)

While trying to Copy SupplierFile1,File2(sheet2) to Masterfile(Sheet2)

After Using Dir to Access the supplier file and copying the data from sheet2 I am doing this 

ActiveWorkbook.Worksheets("Sheet2").Activate
erow = Sheet2.Cells(Rows.Count, 1).End(xlUp).Offset(1, 0).Row
ActiveSheet.Paste Destination:=Worksheets("Sheet2").Range(Cells(erow, 1), Cells(erow, 5)) "This part is showing error"

I am Not a programmer  and tried the solutions available online and YouTube but nothing is working and need to get this  right urgently.. any help would be greatly appreciated (any reference article would also help)
I am Not a programmer  and tried the solutions available online and youtube but nothing is working and need to get this  right urgently.. any help would be greatly appreciated (any reference article would also help)