title: Reporting in Excel 2010 with VBA
body: <p>How can I do this please!?
  I have an excel work book with 60 sheets and all 60 have the same column headers and number of columns.</p>
  
  <p>Each sheet is the name of a country and the rows has names in column A and a status in B and a code D</p>
  
  <p>I need to produce a report using all the 60 sheets that list all the Names by Country where value B =  “XYV” and show the corresponding Value in D.</p>
  
  <p>Hope that makes sense!</p>
  
  <p>I have been trying to use a pivot table across the sheet but I either get Invalid reference if I only select the columns needed (and this takes forever to do!) or insufficient memory if I select the whole sheet.</p>
  
  <p>Can I do this in VBA macro?</p>
  
  <p>Sorry I'm new to Excel in this way so any help would be appreciated…</p>