Macro for Extracting values from one sheet to another sheet based on multiple criteria

[Limzzz]

Hey Pros,

i am not sure if title explains all my problem anyways ..... i will try to explain my problem in Detailed manner. Here is a sample table we are dealing with right now.

Source Roadmap <tbody> </tbody>	Line Item as Reported <tbody> </tbody>	Code As Reported <tbody> </tbody>	Units <tbody> </tbody>	Data Type <tbody> </tbody>	1999	2000	2002	2003	2004
GDP by expenditure>Nominal series>USD>Total <tbody> </tbody>	P per capita (current US$)	AGAJ <tbody> </tbody>	LCU <tbody> </tbody>	actual	45345	554	445	455544	7777
GDP by expenditure>Nominal series>% of total>General government final consumption expenditure <tbody> </tbody>	Gross capital formation (current LCU) <tbody> </tbody>	AFJK <tbody> </tbody>	LCU <tbody> </tbody>	actual	453	453	455	4556	4838
Female>% of total <tbody> </tbody>	Imports of goods and services (current LCU) <tbody> </tbody>	AFJT <tbody> </tbody>	LCU <tbody> </tbody>	actual	456	45645	45646	45456	54533

<tbody>
</tbody>

Now from this worksheet i have to create another table with figures from 2002 to 2004 or on wards. I want to use codes under Code As Reported to identify the column because they are unique. My resulting sheet should look like this

Code as reported	2003	2004	2005	2006
AGAJ <tbody> </tbody>	455544	7777	7777	56354
AFJK <tbody> </tbody>	654745	46928	69119	3197

<tbody>
</tbody>

I have used quite number of codes however i am unable to get the required result. I am new to this so i am having some of problems in coding. some of the hurdles i am facing are as follows;
1. Extracting string of number from year to year.(2002-2018) from data (1990-2018)
2. Writing flexible code which could shuffle between the number of data i want to extract
3. Shuffling between year on year.

Any pros out there kindly help or get back to me if you need any further clarifications