title: Excel - VBA Find info among thousand of spreadsheets
body: <p>So, I have around 5,200 excel spreadsheets in six different folders containing a mix of random spreadsheets and relevant sales data I need. I a need only subset of these sales data. The sales data, are custom sales proposals, made for different customers at various points in time.</p>
  
  <p>First, I need to find all the spreadsheets sates data and move it to a separate folder from the other random spreadsheets. The only aspect in common from these spreadsheets is the name of the first sheet.</p>
  
  <p>Once I have all the sales spreadsheets, I need to find all of those that actually used and filled accordingly (some of them are incomplete). From them I need to copy only a couple of cells that contain the name and price of the current vendor. I need to do this while keeping track of the file name and the customer name (I’d like to create a table in a worksheet with file name, customer name, competitor, price, etc.)</p>
  
  <p>Then, I need to copy the actual bid offer made by our company, contained in one of two sheets of the spreadsheets. The whole workbook normally contains around 12 sheets. A complication is that the sales spreadsheets were somewhat custom made, which means the order and names of the sheets are not uniform.</p>
  
  <p>I am aware that this is a complicated scenario and would greatly appreciate any feedback out there.</p>
  
  <p>And please let me know if I explained the problem clearly enough.</p>