i need to harvest this db http://webprod.cio.sc.gov/SCVendorSearch/vendorSearch.do

Do a wildcard search on any state
click resulting company link

I need all data from each tab (company, contact, emergency, commodities) in a single row with column headings (csv).

Commodity will be tricky since there are multiple commodities per contact. I'm open to suggestions here.

I will need to sort resulting csv by commodity to select the contacts I need.

Possibilities...
A. 2 phase grab
-Grab all commodities
-I select the commodities I want contacts for and provide list
-Regrab contacts searching only for targeted commodities

B. Multiple records
-Grab all contacts
-create additional record (per contact) per each commodity
ex. contact1, commodity1
contact1, commodity2
contact1, commodity3

Open to other suggestions for quickest, simplest method for script. I can sort and further refine data in excel once I have the raw data.

I'll need contacts for all states available.