Edit: Could this help: http://sitestory.dk/excel_vba/merge-data.htm The 'Combine 2 Tables Part'? I also found this: https://superuser.com/questions/1965...ed-excel-files
Those are common problems. The issue with your request is that only those tables listed in my previous post have two common columns. Having at least two common columns is a requirement for combining tables.

This might not work. But, we've got a list of regno numbers in the first sheet. Can't we use a search function to find each regno number in the other sheets. When it finds a regno number, it would copy the contents of the X nearby columns and paste that data into the first sheet. Would that work? Obviously, we'll have to code for blank cells and when there's multiple instances of a regno number.
That would be the same as manually pasting each table, one below the other, (In proper column order,) then sorting the new table on Regno. You wind windup with a series of Stair stepped rows, with each table's entries below and to the right of the previous table, for each regno.

We know that you have the raw data converted to CSV files, We have see the impressive amount of wrok you have already done with that data, We are very sorry that that work was for naught.

I do not believe that one big table is your ulitmate goal. You have never told us what you ultimately want to do with the data.

Please tell us the ultimate goal, let us see the CSV files, and let us recommend a way to reach your ultimate goal.

NOTE: If you let us see the CSV Files, only share the top 5 (Five) lines in each. That is all we need to see. Some of us are already limited to the first 65K lines.