Sort data on excel sheet

For my project I need to organize information on the ecological footprint for 30 different countries which I randomly selected. All of the data for each country's biocapacity and ecological footprint from the years 1990-2013 is located on the excel workbook titled "EF and Biocapacity per country". I need help with transferring that information to the workbook titled "GDP PPP data" so that I may analyze it. I have already set up the framework, and I have already done a color-coded example of what I need done. I simply don’t have the time right now to sort it myself. Please do not change any formatting or do extra work that is not specified below. Below are the detailed instructions: In the workbook titled "EF and Biocapacity per country", there are thirty different tabs on the bottom (from "Ireland" to "Congo Dem. Rep."). As Ireland has already been partially completed, please look now at its corresponding tab. Under the column titled “Record” you can distinguish if the data for ecological footprint ("EFConsPerCap"). Please copy the numerical data under the columns titled "Built-up Land", "Carbon", "Cropland", "Fishing Grounds", "Forest Products", "Grazing lands", and "Total" for each year for only ecological footprint and paste it into the document titled "GDP PPP data". For example, in the tab “Ireland” in the workbook titled "EF and Biocapacity per Country", I copied the data ("built-up land" to "Total") for ecological footprint in the year 1990 (red). I then went to the workbook titled “GDP PPP Data” and pasted it to the corresponding year and country. Please do this for each year, for all thirty countries within a day. Thank you.