Pull Specific Data from Website (Screen Scrape)

Greetings Everyone. I have been attempting this for two solid weeks (including weekends). I desperately need help. It seems like everyone on the net has had some interaction with what I am looking for but not quite enough is said or provided to help me. I am attempting to search for items on the website below:

"URL;https://www.gsaadvantage.gov/advantage/main/start_page.do"

The goal is to go into the site, look up the contractor name, and list all the items they have listed on this (every page). Is it possible to search in the site and pull this info? I have provided a workbook for assistance.
I think I am close to what I need to get this accomplished. Can someone take a look at the code below to see what I am doing wrong? Thanks and God bless.

Please Login or Register  to view this content.

The contractor names are on the hidden tab "Sheet2". They are in column B on that tab. Basically, I want my macro to perform a web query and make a tab for each Contractor. Is this possible?

Basically, what I am trying to do is automate a web query and create a tab for each contractor. I have attached a workbook which is where I started. The workbook only focuses on one contractor at a time and creates a tab for each page. This workbook has a module that prompts at workbook_open to ask for data refresh. Once the query has pulled the info, I have another macro that cleans/parses the data accordingly.

The intent is to be more comprehensive and include all contractors and create tabs for each unique contractor name. I want the cleaning/parsing to be automated in the process. Is this possible? Thank you for the help! God bless.

Either one please. My apologies for not specifying the cross post.

Link to cross post:
http://www.experts-exchange.com/Soft..._27961674.html

---BUMP---


Please help....anyone....? Thanks

I am getting help on another forum (Experts Exchange). Thanks anyways everyone.