I want to scrape data from a webpage that is a pdf

I want to scrape data from a webpage that is a pdf.

Specifically, I want the Weaning Pigs (U.S. Total Composite Weighted Average Price per Head) from the following site:

HTML Code: 

The code that I have written does not work when it hits

Please Login or Register  to view this content.

so I am guessing that I should be referring to this as a pdf rather than an IE.document, but, I don't know how.

I have also attached the Excel workbook that I have written. Thanks for your help!

Please Login or Register  to view this content.

Thanks for getting back to me.
I should have specified that I have already figured out how to do that in PowerQuery but since I am doing 52 sheets per year, I was looking to automate the function via VBA.
The only table that I am looking for is the last one (early weaned and feeder pigs).

Column1 Formula and Cash Low, US$/Head Formula and Cash High, US$/Head Wtd Avg Price, US$/Head Wtd Avg Price, C$/Head
Early Weaned (10-12 lb) 39.66 63 49.06 62.83
Feeder Pigs (40 lb) 59 72 67.38 86.29


So, is there a way that I could import an entire pdf directly from the website? Then I would just take the last table and move the data to a separate sheet and then automatically repeat.

Thanks again

Thanks for the suggestion.
I started a routine by recording a Macro and then started trying to modify it.

What I want to do is to select the first website in the list on the "Websites" sheet, then have the routine go to that site and select the last table on the site and paste it to the respective location on my "USDA Feeders Quarterly" sheet. Then I would like for it to delete the sheet that was created by the Macro.
Then I would like to repeat the process for the next website on the list in the "Websites" sheet and for it to paste the info into the rows bellow what was last pasted. Until I run out of websites in the column.

This is what I have come up with so far:

Option Explicit

Please Login or Register  to view this content.

I have attached a Excel workbook and as you can see, I am being a total "Script ******" and trying to borrow from an old routine that I use for other sites.

Thanks for your help