Excel VBA/Macro for Keyword based search on listed URLs.

Greetings respected team,

Kindly advise if it is possible to create an Excel based VBA or Macro that helps search predefined keywords in predefined URLs.

If possible then,

For example we have a workbook containing three sheets, Sheet1 and a Sheet2.
[Sheet1]
- List of Predefined First Names in Column A.
- List of Predefined Middle Names in a Column B.
- List of Predefined Last Names in a Column C.

[Sheet2]
- List of URLs in a Column A.

Based on the results from the combinations of above two sheets, would it be possible to extract links from every URL where these names are appearing.

If so then we need to create a separate sheet containing URL in Column A and resulted links in Column B. Like this an output of every URLS would be created in a separate sheet of the same workbook.

For example if in an input file [SearchLink.xls] we have -
[Sheet1] - Containing names in their respective columns.
[Sheet2] - Contains a list of URLs in its respective column, say total 10 in count.

Then as an output, in the [SearchLink.xls] there would be total 12 sheets created.
[Sheet1]
[Sheet2]
[URL1]
[URL2]
[URL3]
[URL4]
[URL5]
[URL6]
[URL7]
[URL8]
[URL9]
[URL10]

The assistance on this request would be highly appreciated.

Thank you and Best Regards - AD