Macro for extracting list of row values from one working sheet to another based on unique values in column

[Limzzz]

Hey pros,
I am not sure if i have rightly stated my problem in title of the message.. anyways kindly help me this one...
I have a sheet with hundred of economic indicators(column wise) for a particular country listed from 1990 to 2018( row wise). each indicator has its code in particular column and these codes are unique. Now i have to extract data for certain ( lets say 7 ) economic indicators in another working sheet. These data which are being extracted should contain all the values from 1990 to 2018 in front of it. I have used certain codes but they aren't giving me the required result.

Source Taxonomy Code <tbody> </tbody>	Line Item as Reported <tbody> </tbody>	code	x	y	z	t	1998	1999	2000	2001	2002	2003	2004
GDP by expenditure>Nominal series>USD>GDP per capita <tbody> </tbody>	Changes in inventories (current LCU) <tbody> </tbody>	AFJQ <tbody> </tbody>					50000	17237	72423	278572	752752	752	7527
GDP by expenditure>Nominal series>International Dollar>GDP per capita (purchasing power parity basis) <tbody> </tbody>	GDP per capita (current US$) <tbody> </tbody>	AGAK <tbody> </tbody>					752752	42472	7275	7527	727	7257	75272
GDP by expenditure>Real series>Index (LCU, base year=2005)>Changes in inventories <tbody> </tbody>	GDP growth (annual %) <tbody> </tbody>	AFJU <tbody> </tbody>					5272	75272	75272	7272	7272	7524	77888

<tbody>
</tbody>

I have made a dummy table from which i need to export data, table will explain my problem in detailed manner. From this table i need to create another table with particular code and values from 2002 onwards....
Kindly help!!!