The macro has to be edited. The error you're getting means you didn't edit it for your computer. I colored the parts you need to correct.

1) You need to put in the correct fPath to the folder on your computer where the files are.

2) You need to edit the Master to the name of the sheet you're collecting this data into.

3) Also this macro goes into that workbook.

4) You really should not have blank rows at the top of data sheets. Consider fixing that in the future so they aren't there.