Pull certain information from sheets into a main sheet

Question

Is there one formula to pull information from several sheets into a main one. Example getting Daisy Trucking Inc's information from A-N from sheet 1-8 onto there main sheet. enter image description here

enter image description here enter image description here

enter image description here enter image description here enter image description here enter image description here

user_5632629 · Answer

try:

=QUERY({Sheet1!A:N; Sheet2!A:N; Sheet3!A:N; Sheet4!A:N; 
        Sheet5!A:N; Sheet6!A:N; Sheet7!A:N; Sheet8!A:N}; 
 "where Col2 = 'Daisy Trucking Inc'"; 0)

Pull certain information from sheets into a main sheet

1 Answers