Converting HTML Page In Computer Folder To Excel, CSV, or Reading In Directly?

I am trying to read in some files currently stored in HTML format. They were sent to me by a client. They currently reside in a folder in my network drive, and basically contain a link, that when clicked, redirects me to a webpage with the information that I need.

I am aware I can save the HTML pages as a PDF and proceed in that manner, but there is such a large quantity of files that I am looking for a more efficient way.

Does anyone know if it is possible to write a code that "fetches" the link to the HTML file and then either saves the file as a CSV, XLS, or presents it in a manner that I can directly extract the information I need?

I have attached a simplified example. What would be some basic code for fetching/opening the HTML file and then extracting the State Name and Abbreviation? Is it possible to directly create a SAS dataset with this information?

I tried using my actual file, and it says "specified address not available" - I think it is because the file is from a data management system and not publicly available on the web, so there is no general URL I can use in the file name statement.