Need to show summary result for each country seperatly in one sheet

Hi All... I have a Source excel which has 4 sheets,summary, match,source1 unmatch, source2 unmatch, I have a sample Excel with multi select list box populating the unique list of countries, when i select one country or more it has to display the result for those countires, in all the 4 sheets of the sample Excel, With seperate summary tables for each countries with the static text on the sample excel..For source pls refer the Source Excel, to make it clear, if i select 10 countries I need to show 10 summary table for countries separately in summary sheet(sheet1) and the country name has to be populated on the top mentioning its name as in source and 10 countries records in other sheets..match(sheet2),source1 unmatch(sheet3),source2 unmatch(sheet 4), seperately on the respective sheets, summary for each country should display the results by taking it from the rest of 3 sheet values for that country... I am wondering how to do this, If any one can Please help me out.. thanks in advance..

Can some one help me here please..

No Its different, Here i dont have anything in summary sheet on the smaple target.. I need the summary template on sample source has to be coming in my sample target, if i select 10 countirs sample target has to bring 10 tamplates automatically on summary sheet with respective value for each country in the templates..thanks for asking..

Hi I just want to add an update here.. that my source will not have summary sheet.. just to show the summary template i added it in the source so please donot consider the range values in for summery sheet in source, tARget only will have summary sheet and it should display the sample template showed in source for the number of countries selected. If not clear, please let me know.. thanks..