Google Sheet Query

[volaxe]

Hi there, recently been trying to use Query function in google sheet. What I'm trying to do is combine certain data from all the tabs into 1 Master Summary for easy review. However I'm kind of stuck at the part where I need put multiple tabs in the formula, much appreciated!

<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>https://drive.google.com/open?id=1WNTm4vob1NG7XpheqqMbEZ8agUd8QdjfX1MVM5rAGcM

 

[Norie]

This works without error but I'm not sure it produces the expected result.

=QUERY({'In-8878 Prod'!A1:Z;'Mk75- Mk889'!A1:Z},"select Col1, Col3, Col5, Col7, Col8, Col9 where Col2 = 'Interbank transfer'")

 

[volaxe]

Thanks Norie!! That worked perfectly except that there's a new challenge where the number of rows in each tab is different. Example in tab In-8878 Prod, the last column i would like to select will be A:Z whereas Mk75- Mk889 I will need to take in A:AZ. Let me update the sheet for clearer example.