title: Excel VBA to search for specific text in cell and then copy to another sheet
body: <p>I want to make a macro to copy <code>Date</code> from cell <code>J5</code>, copy <code>Invoice No.</code> from cell <code>H6</code>, copy <code>consumer name</code> from merged cells <code>A6</code> and copy only the amount of the items under product description cell range (B11:B21) for items in invoice sheet and paste those values into another sheet by name invoice-record there is table with headers <code>consumer name, date, Invoice No. Items</code></p>
  
  <p>(Sub Headers of Item1, Item2, Item3, Item4, Item6, Item7, Item8, Item9, Item10, Item11, Item12)</p>
  
  <p>I want my macro to copy these values from Invoice sheet and paste under the headers of each in the table in Invoice-Record sheet. to elaborate it better, I am giving the link of the workbook:</p>
  
  <pre><code>https://www.dropbox.com/s/6wu69cgn3qfvr67/Invoice.xlsx?dl=0
  </code></pre>