title: Excel 2010 VBA How to lookup a value in multiple sheets?
body: <p>I have an excel file with 14 worksheets, i need to lookup for a value in different columns of each sheet, and if its found, return the name of the sheet where the value was found in a list on a summary sheet.</p>
  
  <p>I have tried with if and vlookup function but i can´t find a proper result, also i tried with pivot table but since i have multiple sheets its not working for me.</p>
  
  <p>I am hoping that somebody helps me with a bit of VBA coding to solve this issue. </p>
  
  <p>I am very newbie at coding and VBA and still i don´t understand all of it, so i haven´t tried to code myself, sorry for that.  </p>