Cleaning up data from scraping website URL

Hi I'm making a workbook scraping multiple URLs using macros in Excel 2013.

The problem is the way the website is constructed and it only allows me to select the entire webpages.
This then gets dumped into a worksheet with all the links and loads of other stuff I do not require.

I'm wanting it just to save 2 certain parts. These are on the lines below 2 key headers. Last Activity and Join Date.

Is there anyway to select just these 2 parts. I know in Data > Select from Web will not allow me to select just those fields Shame

But is there anyway to clean all the stuff out I do not want OR is there another way to go about it to get just this data?

Thanks in advance.

Have you tried Microsoft Power Query. Can be downloaded free from Microsoft

Thank you I will check it out now and get back if i have any problems.

Cheers

Not liking it tbh but it probably is the best thing to use.

I just need a little more advice and guidance.

I have a list of ending URLS in a spreadsheet and a name in the second column.

Page | Name | Join Date | Activity
user1.html | User1 | |
user2.html | User2 | |
user3.html | User3 | |

The URL is the same (http://blah.com).

I'm trying to extract Join Date and Activity from the URL + A1-A5 (blank line) when a refresh button or worksheet is opened. (prefered button)

The date is within the html tag <dd> (0) and (1).

Is this Power Query able to do this?

I've managed to find where the JD and Activity is when viewing in Power Query after expanding 20 or so columns.

If you could help further I'd really appreciate it.

Thank you