ExcelMerge | GUI Diff Tool for Excel | CSV Processing library

I'm working on a spreadsheet automation process through VBA and had success so far, but I'm kinda stuck on a single element of it, namely clearing filters before copying. This code is located in a module on a masterfile, and what it does is open every workbook in a folder (each file has a single sheet), copy all data from A2 to AJ(however many rows there are), paste it on the masterfile, then close the file and move to the next one in the folder, until all files have been merged into the master, one block of data directly below the previous one. It works perfectly. The issue is that in some cases, these files might have filtered columns, and everything that is filtered out will not be copied over. These files are sent from another department. I did search SO and found different ways to clear filters, I even tried a code that worked on its own, but I just can't make them work on my code for some reason, maybe I'm placing them in a wrong spot or something? Also, is there anything that I should change to clean/optimize the code?

Thanks for your time and attention!