Excel data anlysis

I have data on approximately 200 groups over 40 years. I have the data on 40 different excel sheets, and each spreadsheet lists all the groups for that particular year. I want to know how these groups are changing over time in one specific criteria. The criteria is in a single column on each sheet. The list groups do change slightly from year to year, as occasionally groups did not submit data. So to analyse the criteria you must carefully cut and paste the columns from 40 sheets into one big sheet. There will probably be just over 200 rows, one for each group. There will be 40 columns, one for each year. But you must be careful to make sure the right number goes in the right box, because the rows are not exactly the same each year. You cannot do a simple 'cut and paste'. I have done the first four years as an example. If this project goes well, and i have enough money, I will post two other projects looking at two other criteria