Excel for Mac VBA Specialist - URGENT -- 3

I have an Excel Spreadsheet that was made using Excel 2016. It uses VBA to select and import 3 txt files, unlock/lock sheets, update PivotTables, clear data, fill down formulas to the last used rows, sort and refresh data. However, it does not work properly in Excel for Mac 2011 or 2016. It either freezes or throws a 1004 error. The Mac specific code to import txt files is already written, and works properly. I need to get the other bugs/incompatibilities in VBA sorted so it works properly in Excel for Mac. Specifically - the issue with Excel for Mac is that when importing this data it does not import. When clicking Load/Refresh All on the Dashboard, it throws an error or freezes. 2016Jan_Monthly is the file used for import. Must have Excel for Mac 2016 and be proficient in VBA.