Sub test()
On Error Resume Next
Dim i As Integer
Rows("2:1048576").ClearContents
With ThisWorkbook.Sheets(1)
Set fso = CreateObject("scripting.filesystemobject")
Set ff = fso.getfolder(ThisWorkbook.Path)
For Each f In ff.Files
If Not f.Name Like "*" & ThisWorkbook.Name & "*" Then
Workbooks.Open f
For i = 1 To Sheets.Count