Consolidating data in multiple sheets into SIngle Sheet

Here is my problem.
I Have country name in first column.
Year ranging from 2012 to 1999 in 2nd column
Some statistics like gdp in 3rd column

I have more than 10 similar sheets with differenct statistics.

I wan to combine all these sheets into one so that.

I select the country names and year or years I want to review it shows all the statistics of that country(ies)

For Reference I have added a sample file.

The reason I don’t want to simply copy paste the statistics column from the each sheet into the Summary sheet is I want to keep the source file. So next time when simply update the source sheet summary sheet also gets updated.

I have included in the attached file how Resulting data will look alike.