File Combination Problem

[vichisov]

I have 80+ files that I need to spliced. Sample attached. The table A9:F64 will always have the same columns, but possible different lengths. A9 will always be the top left corner of the table. I am trying to splice all into one with with C7 from each repeated in column A and then the table to be shifted over one. So outcome would be a new file, combining 80+ files in a folder where the tables are shifted over 1 and Column A is C7 repeated for each table.

I hope this makes sense.

Thank you,