Referring to thepost in Excel Worksheet Function.

Does anyone have any suggestions on how to write a macro to load a list of
web links into specific worksheets?
For example,
Under worksheet "Lists", there is a list of names for worksheet under column
A, and there is a list of web links under column B.
I would like to load all the web links from the first row to the last row.
Does anyone have any suggestions on how to do it in excel?
Thank you very much for any suggestions
Eric