VBA to search internet and copy data into sheet based on search

Hi all

I have a particularly tricky / interesting request.

I am trying to work out a way to create a VB script that will search the internet for data and copy matching results back to the sheet in a row per data search.


Here’s an example:

I type a name into Userform textbox and click search....
The textbox contents is copied (maybe using send keys method)
A webpage is opened at Google home page and the textbox contents are pasted in search field and the send key scrip to start Google search.
As results are displayed in Google, any results that match the textbox value are copied as rows to a sheet in excel.
This process needs to loop until completed (unsure how to determine when a search is complete)

Reason:

There are two reasons I want to do this...
1) I am attempting to create a Gaming Clan database that will have an up-to-date list of members.
2) I want to be able to search and add to the database adhoc or on a timed schedule (for the adding part)

Maybe VBA is not the best way to do this (I don’t know what is) but I hope there is very talented person that can help me or lead me to the right direction.

Many thanks to all that read this!

Thank you for this direction.
It has saved me a lot of hassle and time.

Marking as solved as have used a Chrome extension called Websrapper, It is really great! Basic, but does the job