Copying data across workbooks in the same folder to masterfile

To copy worksheets from MyFile workbook to code workbook :

PHP Code: 

    For N% = 1 To 4
        With ThisWorkbook.Worksheets(N).UsedRange.Rows
            Workbooks(MyFile).Worksheets(N).UsedRange.Copy .Item(.Count).Cells(1)(2)
        End With
    Next 


Do you like it ? So thanks to click on bottom left star icon « Add Reputation » !