title: Updating one sheet by date in another sheet
body: <p>How can I update information on one sheet by entering a date that refrenced a list of data on a seperate sheet?</p>
  
  <p>For example Sheet1 has a weekly sched. and Sheet2 has a log of events listed by date. I would like to simply enter a date on Sheet1 (i.e. Week of: 9/17/12) and have it update the rest of the sched with the coresponding events from sheet2. 
  (the information I'm using is all text)</p>
  
  <p>Thank you in advance!</p>