As you did not answer for the Excel table so well read again my previous post in order I get at least the expected answer !
If you modify the original 'tt' data with creating the Excel table so do not, no sense wich such mixed data.
As your last attachment is just good enough to be trashed so hoping the next one will better reflect at least your real workbook
without this time such data errors …
if you mean the code doesn't deal any changes for tt sheet after run your code . ok ignore it , just I will import data from the files , then your code will arrange them and no need changes for tt sheet after the macro arrange all of data