you can try the Access Web Sync Seminar

The basic idea is to write code that reads and parses the HTML code of a webpage, gleans through all the "a" tags (where links are stored), and obtains the link addresses.  But web pages and their HTML code may get modified without notice.  When that happens, you may have to rewrite the code at your end.  This is a problem if you have a mission-critical application that may suddenly stop working and require an immediate code rewrite.

I have a movie collection application in Access in which I use this method to retrieve movie data from IMDb; and I have to modify my code at least two times a year because IMDb gets modified pretty often, as is usually the case with busy websites.

All links are stored in "A" tags, but the trick is to find which "A" tags have the links you want.  You have to look at the "context" of the webpage.  Maybe certain links are listed under certain headings -- when you search Richard's site, results are shown under course outlines, news headers, comments, etc.  Maybe some are under certain "classes" in the HTML code.  All this has to be done with VBA, for each webpage, and updated whenever a webpage changes its HTML code, maybe even slightly.

Websites usually frown upon this kind of activities.  That's because when you try to glean info from the sites without visiting the sites yourself, you are a "bot."  Many sites have anti-bot measures.  If they ask you to do one of those "I'm not a bot" thing, you have no way to overcome that.

These are just a few issues you will face.