Alternative to Query or Filter formula

  1. There are three tabs in the sheet - Tab 1, Tab 2, and Tab 3.
  2. Both Tab 1 and Tab 2 have three columns - column a for Company, column b for Receipt, and column c for Date.
  3. For column a, there will be two data inputs - “LS” and “CMS”.
  4. I need to compile all the records from Tab 1 and Tab 2 where column a is “LS” in Tab 3

Tried using Query and Filter formula, but it says formula is not supported, any alternatives on it?