Is there a way to create a macro in order to copy the entire page in an
internet site to excel?

Ill try to explain it better :

I have a list of hyperlinks in a sheet (sheet1), the macro should open these
hyperlinks and copy all the content of the page and paste it to a certain
sheet (sheet2) in my workbook.

Is this possible?