title: How do I aggregate data across multiple worksheets in excel?
body: <p>I've been trying to figure this out for some time now. We utilize the same evaluation through survey monkey for every one of our training sessions. There are 8 questions in total. For a single survey, we get the results back in an excel format with the data spread across 8 separate work sheets. What I would like to have is a formula that can be used to aggregate the data for each one of the questions across multiple spreadsheets. </p>
  
  <p>For example, we want to know the average response for Question #1 from the training sessions for client ABC, DEF and HIJ. Hope that makes sense.</p>
  
  <p><a href="http://www.supermotors.net/getfile/987439/fullsize/question-1.jpg" rel="nofollow">Question 1</a></p>
  
  <p><a href="http://www.supermotors.net/getfile/987441/fullsize/question2.jpg" rel="nofollow">Question 2</a></p>