title: How to search and combine several sheets in Excel?
body: <p>I am trying to do an Excel sheet to do some statistics about athletes in world cup competitions. </p>
  
  <p>I have a worksheet on excel for every competition, plus one for the overall result after the season (which thus has a list of every athlete that competed at least once). </p>
  
  <p>The worksheets have the name of the location where the competition happened. Eg: PARIS.</p>
  
  <p>I have one more sheet, named "Athletes". what I want to do there is:
  for every athlete appearing in the "overall" list, I want the columns after the name to be filled with the results in every location the athlete completed in. </p>
  
  <p>For example</p>
  
  <p>Name Paris London LA Berlin</p>
  
  <p>Amoros 1 5 / 7</p>
  
  <p>Bilboni 2 43 3 12</p>
  
  <p>To find "1", I want excel to search the sheet "Paris" for "Amoros" and extract the ranking in the row it finds "Amoros".</p>
  
  <p>Let's say it finds "Amoros" in cell L57, then the corresponding ranking to extract will be in K57. "/" indicates Amoros didn't compete in LA.</p>
  
  <p>I am using Excel 2016 on a Mac.</p>
  
  <p>Thanks a lot in advance!</p>
  
  <p>Ben</p>