VBA to get content from internet

[mukeshc]

Hi

Need a help.

In column A of sheet 1, I have links of certain section of company websites.

I need to copy all the content from that section to sheet 2 of excel once all content got copied from first link move to 2nd link and copy all content and so on.

however i also need an identifier for contents that from where they are from which link.

at the moment i m doing it manually is there any way to do it through macros.

thanks in advance.

regards
Mukesh