I am trying to come up with a simplified way (instead of copy and
pasting thousands of lines weekly) to pull data from a specific web
site and pull the data into an excel file.

Where I can I begin to find information on this topic? Is there a way
to implement a query through excel to scan a site to pull specific data?