1. There are 6 PDF files containing lists of companies and 5-7 other fields about the company. (3 reports with 500 co's each; 3 reports with 50 co's each).
2. Need to put all company data into a single XLS under two tabs (based on two types of reports)
3. Not all the PDF files provide data in the same format, so in some cases one or two fields (e.g. name of CEO) may have to be looked up from their website or the internet.