VBA Code - Run-time Error 1004 can't find file

Hello,

I am VERY new to VBA and I am getting a strange error when I run my macro. The code is below and the goal is to combine "Sheet1" of several workbooks into a new workbook (basically making a master for all of my spreadsheets). When I run it, I get the error pictured below, however, the file it cannot find is definitely in the folder. Can anyone help me solve this error? THANK YOU!

Capture.PNG

CODE:

Sub LoopThroughDirectory()
Dim MyFile As String
Dim erow
MyFile = Dir("C:\CE Sign In\")

Do While Len(MyFile) > 0
If MyFile = "zCE Class Sign In MASTER 2018.xlsm" Then
Exit Sub
End If

Workbooks.Open (MyFile)
Range("A2:O4").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, 15))

MyFile = Dir

Loop

End Sub