title: Excel Data validation won't sort based on column value
body: <p>I have a simple absence schedule file, in sheet DATA column B there are some names of co-workers (or letters in this case..) in sheet JAN column C those names appear again (if a 1 is selected in sheet DATA column C) but that's not the point.</p>
  
  <p><strong>Problem: those names have to be sorted sometimes (when new one's appear) but the DATA VALIDATION columns in sheet JAN don't sort with them (see colors in rows)
  I don't want to use VBA because i don't know it, so hopefully there is a formula solution (use formula in the data validation popup? something with INDIRECT?)</strong></p>
  
  <p>Hopefully someone can't help me out with this.</p>
  
  <p><a href="http://ufile.io/xyymh" rel="nofollow noreferrer">TEST FILE</a></p>
  
  <p>As in picture below, left side is the DATA SHEET where there are some names filled in, on the right side is the JAN SHEET where those names are displayed with an IF formula, when we sort the names in DATA SHEET they will sort in JAN SHEET as well, but the DATA VALIDATION in JAN SHEET from column D tot H isn't changing with it. I don't want to solve it with VBA because i don't know it, so thought to fix it with a formula, but can't find a solution.. read something that you can add a formula to the data validation list popup (INDIRECT...).</p>
  
  <p><a href="https://i.stack.imgur.com/NKQRP.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/NKQRP.png" alt="enter image description here"></a></p>