Get data from multiple hyperlinks

I have a list of over 200 web hyperlinks in an excel spreadsheet (2010). Is there a way to have Excel open each link, get the information & import it back into the same spreadsheet?
For example, each hyperlink is for a different assignment. I need it to pull the type, requirements, duration & compensation. so the spreadsheet looks something like this:

Assignment 1 – Type – Duration – Requirements – Pays
Assignment 2 – Type – Duration – Requirements – Pays

Is there a to do it?