title: Merging and Adding Data in Excel Worksheets
body: <p>I have 8 sheets of data (from Dec 2014 to July 2015, separated month wise). Each sheet contains monthly data (e.g. Dec 2014 sheet contains data of dec 2014 in three columns namely AC #, Name, Amount).</p>
  
  <p>Dec 2014 Contains Data as Mentioned Below:</p>
  
  <pre><code>A/C #     Name     Dec 2014
  A12       ABC       100
  A13       CBA       200
  A14       BCA       300
  </code></pre>
  
  <p>Whereas January 2015 contains data as below</p>
  
  <pre><code>A/C #     Name     Dec 2014
  A12       ABC       5
  A13       CBA       300
  *A15       IJK       900*
  </code></pre>
  
  <p>All sheets contains mostly same data but some additional data based on customers added in that month or amount. E.g. January 2015 may contain an additional client a/c #, name and amount of January 2015 as marked above.</p>
  
  <p>I want a consolidated sheet of data where all data is arranged as below:</p>
  
  <pre><code>A/C #     Name     Dec 2014     Jan 2015     Feb 2015     Mar 2015     Apr 2015
  A12       ABC       100          5
  A13       CBA       200          300
  A14       BCA       300          0
  A15       IJK       0            900
  </code></pre>