title: Autofilling spreadsheet row when date is (ex: today) and value "name" is in that row
body: <p>i'm trying to get some info from another spreadsheet using IMPORTRANGE and VLOOKUP.</p>
  <p>I have created a new spreadsheet and named it after a date of the month ex: 21 February
  In another sheet, i have a big list of dates where each date has a phone number, a name and a persone who this &quot;contact&quot; has been asigned.</p>
  <p>I want that whenever this list of dates is updated, they get sent into different spreadsheets.</p>
  <p>Example:
  <a href="https://i.stack.imgur.com/2KQE3.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/2KQE3.png" alt="enter image description here" /></a></p>
  <p>In the other spreadsheet i want to automaticall fill in the sheet based on the DATE which on the example above is 21.</p>
  <p>So, Toms sheet should look like
  <a href="https://i.stack.imgur.com/YKnYW.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/YKnYW.png" alt="enter image description here" /></a></p>
  <p>Any idea what formule can i use combined with IMPORTRANGE?</p>
  <p>Best regards.</p>