Copying worksheets from multiple workbooks into current workbook

Hi i was wondering if anybody if you guys could help me out?

Im trying to copy multiple workbooks and just save it into only one worksheet.
I have 2000 diffrent workbooks with the diffrent amount of rows, The ammount of cells is the same and it dosent change.

Im new with this kind of stuff so i'm thankfull for all help u can offer, i cant make it work so edit it how ever u want..
i dont have any idé about what im doing so help me..
im working on a excel 2010

This is what i got for the moment..

Sub LoopThroughDirectory()
Dim MyFile As String
Dim erow
Dim Filepath As String
Filepath = “C:\test\”
MyFile = Dir("test\")

Do While Len(MyFile) > 0
If MyFile = "master.xlsm" Then
Exit Sub
End If


Range(Range("a1"), ActiveCell.SpecialCells_(xlLastCell)).Select
Selection.Name = "PivotData"


Workbooks.Open (Filepath & MyFile)
Range("A2:AD20").Copy
ActiveWorkbook.Close

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

MyFile = Dir
Loop
End Sub