title: Need to populate master list from many different sheets in excel
body: <p>So lets say I have 3 different sheets each with information on them like this:</p>
  
  <p>Sheet 1    Sheet2     Sheet 3<br>
  item1|2    item2|7    item1|4<br>
  item3|5    item3|6    item6|2<br>
  item9|7    item8|4    item7|8  </p>
  
  <p>The first part (code#) is a code for an item. The second number is the quantity of that item. What I need to do, is to be able to populate a master list which will pull the quantity of each item and sum them up. In the above case, the master list would look like this:</p>
  
  <p>item1|6<br>
  item2|7<br>
  item3|11<br>
  item4|0<br>
  item5|0<br>
  item6|2<br>
  item7|8<br>
  item8|4<br>
  item9|7  </p>
  
  <p>I'm sorry if this is confusing but I really need some help!</p>