Copy data from multiple workbooks to one master worksheet

[jevi]

Hi All,

I did look online but I am not finding the solution that it works. I have a folder which have 20 o more files in xlsx where they have data just on the first sheet "Sheet1" which the columns are always the same from B4 to E as the row data might dipends..so one file might have 10 rows of data and another one 20 rows of data etc. I would like to copy all the data of this files just to one master sheet.

Thank you,

 

[jevi]

Now it says that can't find the path and gives this error in yellow:

For Each File In CreateObject("Scripting.filesystemobject").GetFolder(Path).Files

I will upload the data as I have sensitive data so need to change them. sorry