Yes, ignore #16. It has errors built in. # 19 does not have those errors, but may have others.

in this part
If Fn >= 10 Then 
                MsgBox "IT Works! Stopping Sub" 
                Exit Sub 
            End If
Change Fn >= 10 to Fn >= 1

This will stop the code at the end of the first file. it should print some thing in the first row on the worksheet.

As each of your CSV files are ~200 lines. Please attach two here so we can have a meaningful test on our computers. You can zip them into one if you please.

So not despair. This is typical of programming. it is just slower with remote programming.