VBA : Pull Data From Multiple Sheet Into 1 Sheet Based On Criteria

hi all..

the code below work to pull data from multiple sheets into 1 sheet in the same workbook.

Please Login or Register  to view this content.

i want to pull from across sheet (random sheet) data from sheet "summary" & "country" into sheet "Master" in certainty cell - please check yellow shading
based name of place/country (e.g. Hongkong, Bangkok, USA, France, Brazil.
i have use dropdown list in sheet "Input" to change data in sheet "summary & country" but the line/rows keep retain/same for each city/country for example in sheet "summary" my data in rows 10 , col G, H, J. If i suit name city e.g. from Hongkong to Bangkok keep retain rows 10 with different data

here my attachment file

would you help me out, greatly appreciated..

john m

i think it's difficult . but i have edit with new sample for more easy

i try to modified my question like this cause my language is not well & maybe you confused
1. my target in sheet "Master" start col B9 down right till K13 with my data (will be pulled) in sheet "Summary & Country" in cell with number "yellow" shading (rows KEEP IN THERE - not change rows)
2. i want to pull data from sheet "summary & country" into sheet "master" based on name of city/country like Hongkong, Bangkong, UsA....etc
3. my desired result in sheet "master" with criteria:
- if in cell A9 is Hongkong -- pull data from sheet "summary & country" into sheet 'master" and placing in cell B9 till K9.
- if in cell A10 is Bangkok -- pull data from sheet "summary & country" into sheet 'master" and placing in cell B10 till K10.
- if in cell A11 is USA -- pull data from sheet "summary & country" into sheet 'master" and placing in cell B11 till K11.
- etc...
4. i want when running macro, at first show msg box "select city...." then run/click ok
5. for sample please, check in my first OP

thank you

similar posting
https://www.mrexcel.com/board/thread...-cell.1192616/