title: Get all rows from a sheet, into another sheet, where each row contains a cell matching a certain value
body: <p>I'm looking for a solution without VBA due to work limitations. </p>
  
  <p>The schema of my sheet is as follows:</p>
  
  <pre><code>SheetName: 'Spend Track'
  Row 4 - headings
  A     B           C         D            E        F     G        H      I    J
  Date, Originator, Supplier, Description, Receipt, Type, Account, Gross, GST, Net
  
  Row 5 onward is data. 
  </code></pre>
  
  <p>In another sheet (called <code>Kevin</code>); I want all the rows from Spend Track! that 
  match the condition <code>Bx='Kevin'</code>. Where x= the given row number.</p>
  
  <p>So if Spend Track has 10 rows, 3 of which belong to Kevin. The sheet <code>Kevin</code> will have 3 rows and will update when new rows are added in <code>Spend Track</code>. </p>
  
  <p>Thanks!</p>