Google Sheet : Import Range Based on Certainty Column With Single Formula

[Jhon Mustofa]

hi all...

i have problem how to importrange with criteria name of City as parameter. i want 1 formula can able cover all range/rows
this my link
https://docs.google.com/spreadsheets...it?usp=sharing

this step:
1. my formula in sheet REKAP ALL IKU cell B5-B10.
2. sheet SBSK (1/13) as sources with data from B7 till H12

here this formula for work in 1 city...i want the formula work all city without edit 1 by 1
=ArrayFormula(({IMPORTRANGE("https://docs.google.com/spreadsheets/d/1NrhJ863JaExJge4ZeAW0kYpXYI8_kzaNs6Dupdf2Mko";"SBSK (1/13)!b$7")\QUERY(IMPORTRANGE("https://docs.google.com/spreadsheets/d/1NrhJ863JaExJge4ZeAW0kYpXYI8_kzaNs6Dupdf2Mko";"SBSK (1/13)!B$7:h$7");"Select Col2, Col3, Col4,Col5, Col6 Where Col2 ='KPKNL PADANG'";1)}))

how to fix this problem, 1 fill data based on name city with 1 formula at once

anyone help me, greatly appreciated...

john m