title: Filtering data from multible sheets in to a grand total
body: <p>Is there a simple way to collate the same data from three sheets into a grand total. My issue is that the data might not be exact on all sheets.</p>
  
  <p>The example would be, I have a list of suppliers on Sheet 1 and Sheet 2 with their sales figures beside them in column 2.</p>
  
  <p>Sheet 1 reads </p>
  
  <p>Supplier 1 36
  Supplier 2 56
  Supplier 3 12
  Supplier 4 76</p>
  
  <p>Sheet 2 reads</p>
  
  <p>Supplier 1 23
  Supplier 2 48
  Supplier 4 16</p>
  
  <p>I would like to create a third sheet that totals all the suppliers so would read</p>
  
  <p>Supplier 1 59
  Supplier 2 104
  Supplier 3 12
  Supplier 4 92</p>
  
  <p>I would usually sort by name and do a simple calculation but as every row won't be identical, this doesn't seem possible. I need it to total the cells with an identical name.</p>
  
  <p>Any help is as always greatly received and much appreciated.</p>
  
  <p>Thank you</p>
  
  <p>Mark </p>