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.


[TABLE="width: 500"]
<tbody>[TR]
[TD][TABLE="width: 171"]
<tbody>[TR]
[TD]Source Taxonomy Code[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 284"]
<tbody>[TR]
[TD]Line Item as Reported [/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]code[/TD]
[TD]x

[/TD]
[TD]y

[/TD]
[TD]z

[/TD]
[TD]t

[/TD]
[TD]1998

[/TD]
[TD]1999

[/TD]
[TD]2000

[/TD]
[TD]2001

[/TD]
[TD]2002

[/TD]
[TD]2003

[/TD]
[TD]2004

[/TD]
[/TR]
[TR]
[TD][TABLE="width: 171"]
<tbody>[TR]
[TD]GDP by expenditure>Nominal series>USD>GDP per capita[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 284"]
<tbody>[TR]
[TD]Changes in inventories (current LCU)[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 53"]
<tbody>[TR]
[TD]AFJQ[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]50000


[/TD]
[TD]17237[/TD]
[TD]72423[/TD]
[TD]278572[/TD]
[TD]752752[/TD]
[TD]752[/TD]
[TD]7527[/TD]
[/TR]
[TR]
[TD][TABLE="width: 171"]
<tbody>[TR]
[TD]GDP by expenditure>Nominal series>International Dollar>GDP per capita (purchasing power parity basis)[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 284"]
<tbody>[TR]
[TD]GDP per capita (current US$)[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 53"]
<tbody>[TR]
[TD]AGAK[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]752752[/TD]
[TD]42472[/TD]
[TD]7275[/TD]
[TD]7527[/TD]
[TD]727[/TD]
[TD]7257[/TD]
[TD]75272[/TD]
[/TR]
[TR]
[TD][TABLE="width: 171"]
<tbody>[TR]
[TD]GDP by expenditure>Real series>Index (LCU, base year=2005)>Changes in inventories[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 284"]
<tbody>[TR]
[TD]GDP growth (annual %)[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 53"]
<tbody>[TR]
[TD]AFJU[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]5272[/TD]
[TD]75272[/TD]
[TD]75272[/TD]
[TD]7272[/TD]
[TD]7272[/TD]
[TD]7524[/TD]
[TD]77888[/TD]
[/TR]
</tbody>[/TABLE]

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!!!