title: Excel - Combining same names in 3 different sheets and adding their values
body: <p>This is a project in school, sorry I just have a basic <code>VLOOKUP</code> knowledge in Excel. I have three sheets named: pasta, pastries and cakes. So basically this is a tally of how much we sell, and on the 4th sheet, we must list the TOTAL payment each person ordered from each of the 3 products above.  </p>
  
  <p><a href="https://i.stack.imgur.com/7hzLn.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/7hzLn.png" alt="Snapshot of all the sheets"></a>  </p>
  
  <p>so in the images, those 3 sheets are the total payment each person must pay on each product. If you notice, there are duplicate names within the SAME SHEET and WITHIN THE 3 SHEETS. Like Joey's name appears twice on the pastries sheet, and once in the cakes sheet.</p>
  
  <p>So basically i think you're getting my drift, I want in sheet 4 to appear all the payments joey must make in all three products. Basically determining/looking up all same names and adding all the values, then listing everyone else. The closest end I was able to achieve in consolidate was to create 3 more tables in sheet 4 with each product, <code>VLOOKUP</code> all info, create a 4th table in sheet 4, and do consolidation (see sheet 4). But the problem is other than the fact that it is such a mess, they do get consolidated, but only after the consolidate program is entered. But if another input was made in the other 3 sheets, lets say joey buy 3 more pastas, it does not update anymore. Clicking create links in consolidation puts out an error.</p>
  
  <p>I tried searching on youtube  and forums stating the way of "Consolidate", but it always either messes up the whole sheet, adds a column in between, and other stuff. So I may want to do this in <code>VLOOKUP</code> way, so that it can be dynamic, meaning that the consolidation changes automatically EACH TIME an input is made/changed. And it is much cleaner, as I do not have to create 3 more tables in sheet 4 to show the summary of each product.</p>