Website Data Extraction for Contacts Spreadsheet

We require a spreadsheet created, one with the following information:

This project MUST be completed with an automated program.

Please see the attached spreadsheet as a sample spreadsheet that must be completed.

There are approximately 20,000 to 50,000 total contacts, however, not every contact will have a phone or email address

Each listing has a link similar to this:
view-source:https://www.thepmd.com/listing-company.aspx?companyId=1223&hasDrugs=0

You will start with companyId=1 and continue until companyId=99999

You will be able to view all of the company and contact information in the page source

We need every company, starting with ID=1 through ID=99999

For each contact, you will enter in:
Company Name
Company Title
Street Address
City
State
Zip (in separate fields)
Company website
Company phone
Number of employees
Revenue
Company Description
Company Area
First Name
Last Name (found on the far right of the same line as the first name)
Title, Product
Phone
Email

(in the (<div id="ParentRepeater…) section, you will find the Company Area and Contact information). There will be one or more contacts under each (<div id="ParentRepeater…) section.

page source example:

<div id="ParentRepeater3_Div1_19">
<b>R&D/Regulatory</b>
</div>

<div class="containerJobFunction">
<div>
<td valign="top">Richard Rapoza, PhD </td>
<td valign="top">DVP, Global Clinical Affairs </td>
<td valign="top"> </td>
<td valign="top"> </td>
<td valign="top"><a href="mailto:xxx@xxx ">xxx@xxx </a></td>



Attached is a spreadsheet with a sample of what each record should contain. You must follow this exact spreadsheet layout.

You have two weeks to accomplish this task
Funds will be put into an escrow account.
We have completed more than 200 Freelancer projects.