SO below is the short version of what I was able to do in excel. What I did was had certain fields be collected and stored into variables. A webpage would open up and enter the fields. In this case it was mostly address search it was entering. It would click the search, and then click again to bring up the GIS map on this page.
If CellAssessor = "pinalassessor" Then
SiteLink = "http://pinalcountyaz.gov/Departments/Assessor/Pages/ParcelInfoSearch.aspx"
TextboxNumberID = "ctl00$m$g_f1ed9e0e_852a_4270_8b23_90651396ae13$ctl00$ctl02$txt_Number"
TextboxDirectionID = "ctl00$m$g_f1ed9e0e_852a_4270_8b23_90651396ae13$ctl00$ctl02$ddl_Direction"
TextboxNameID = "ctl00$m$g_f1ed9e0e_852a_4270_8b23_90651396ae13$ctl00$ctl02$txt_Name"
TextboxSuffixID = "ctl00$m$g_f1ed9e0e_852a_4270_8b23_90651396ae13$ctl00$ctl02$ddl_Suffix"
ie.Visible = True
Application.Wait Now + TimeValue("00:00:2")
ie.Document.all(TextboxNumberID).Value = Item1
ie.Document.all(TextboxDirectionID).Value = Item2
ie.Document.all(TextboxNameID).Value = Item3
ie.Document.all(TextboxSuffixID).Value = Item4
But I haven't found anything on getting address entry into the fields.