I am trying to pull certain data from webpages in separate columns using
existing hyperlinks within Excel.

For example, for the following hyperlink
"http://scoweb.sco.ca.gov/UCP/PropertyDetails.aspx?propertyRecID=5145088"

I am trying to create a formula or macro / VBA to capture the following
contents for the following fields:

Owner's Name: AMERICAN CANCER SOCIETY
Amount: $70.00
Type of Property: Vendor payments
Reported By: CITIZENS BUSINESS BANK
Reported Address: UNKNOWN , UNKNOWN