Data Extract from Excel 2007 files (XLSX)

I have 75 files (sample attached). I need the files split in the following way. At the top part of the file is a list of IPs. I need those just dumped into a CSV file. The second section of the file contains data in multiple columns. Column A first row - contains a single IP Column A & B underneath (row 2-n) contains an infection name & date Column C first row contains a risk score (replicated 3 times, just need one) Column C row 2 contains company name Column C row 3 contains domain Column C row 4 contains region Column C row 5 contains asn Column C row 6 sometimes contains a proxy with a type I need this data in a seperate CSV. I have 75 files roughtly and it's about 16MB of data uncompressed. It should be relatively easy to extract, you can probably do it with a macro in excel or with just straight code. ## Deliverables Sample file attached.