Simple Excel Formatting

Have 13 separate Excel files which contain formatted data based on the name of a country, a variable with a value and a year. Each document has 5830 rows, (201 countries by 21 years) and three columns, country name, year and variable. The requirement is to re-format data into separate Excel files based on each year, 1981-2009, with each file containing the 13 variables for each country. The layout of this file has been produced and there are 204 rows of countries with 13 variables as columns to be entered. A complication to be aware of is that; within the 13 separate Excel files, there are 11 files with exactly the same list of countries and 2 files with another list of countries. The differences between each country list and the desired final country list are minor and have been documented in a separate Excel file. This is regarded as a test project. If successful, intention is to have a steady stream of similar tasks, with potentially a further 250 files to be formatted.