Is there a way to import the source code of a website into excel?

I can do this manually by going to a website, then selecting "View" --> "Source" and then copying and pasting this text into excel. I wondering if there is a macro command that can do this for me automatically everyday.

Once i have the data in excel, I'll be able to extract what i want. I've looked at the web query function in excel but the data i want isn't always in table form.

Cheers
Schwizer