hi all..

how to pull data using Importrange from multiple sheet into one sheet with criteria like this
i have 3 sheet ,my target in sheet "my expected" .
how to pulling data with criteria name cell "All City" from Col."Target" and Col "Actually"
please, check this share link
https://docs.google.com/spreadsheets...it?usp=sharing

any help. thank you so much

john m