title: EXCEL: Pull data from one sheet and display on another sheet depending on today()
body: <p>I have a series of duplicate sheets inside an excel document called SUNDAY, MONDAY, TUESDAY, WEDNESDAY, THURSDAY, FRIDAY and SATURDAY, with a master sheet called 'Dashboard', on the dashboard I want to display information from the weekdays depending on what date/day of the week it is.</p>
  
  <ul>
  <li>In cell B6 on each of the weekday sheets is a date</li>
  <li>In cell L1 of each of the weekday sheets is information I want to pull through onto the dashboard</li>
  <li>I need a formula on dashboard to look look at cell b6 in each weekday sheet, and if it matches TODAY() then pull cell L1 value from the matching today's date sheet and display it in a cell on the dashboard </li>
  </ul>
  
  <p>can anyone help? I've got close with IF(OR but not quite there, not sure if I'm going about it the correct way, any help much appreciated!</p>
  
  <p>Thanks, </p>
  
  <p>Sam.</p>