title: How can I extract rows of information from multiple sheets by typing in a date
body: <p>I need to extract data from multiple sheets in excel. I have made one excel workbook with different repair schedules for different properties. On the first sheet I need to be able to type in a date for example 12/21/2011 and then have it pull each row of information for that date from all the properties. I need to be able to pull each person's information for that specific date so that I can see each repair and that needs to be done on that day.  This would be so that it can be printed and then taken for repairs to see the location, numbers, times, etc. Or to be able to see what repairs where done on specific dates.</p>
  
  <p>The colum headings are 
  date-- time --resident name--phone number--address--reason for visit---visual meter read--MTU meter read--MTU ID--Account number--Action Taken--</p>
  
  <p>I have figured out how to record a macr, but I can't figure out how to pull the information.  I did try to use Vlookup but it doesn't work for different sheets.  If anyone could help I would really appreciate it</p>