Coding to pull data from ERP system website

[flwoOrlando]

Is there a way to create a macro for a 3500 line excel file to take the prepopulated weblink, paste into a web browser and then grab a 10 digit code that is always in the same spot?
The data I want to grab is also visible when looking at the data in chrome source, so the grab could be like find a specific ID and then give the next 10’characters... and put that code next to the weblink in excel.

The web URL is something like this: www.ERP.com - then I log on. I want the macro to pull the line detail: https://erp.com/.../ro/product_detail.jsp?companyId=XXXXX&productId=YYYY and then find the ScheduleBNumber 3902100000 or whatever the actual number is, and paste it back into my spreadsheet...

I have taken the time to prepopulate the company ID and the Product ID to keep it simple.
<code style="margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; font-family: Consolas, Menlo, Monaco, "Lucida Console", "Liberation Mono", "DejaVu Sans Mono", "Bitstream Vera Sans Mono", "Courier New", monospace, sans-serif; vertical-align: baseline; white-space: inherit;"><TD class="verdanaBlue">Schedule B Number&nbsp;:&nbsp;</TD>
<TD class="verdanaBlue" id="scheduleBNumber">
3902100000<input type="hidden" name="scheduleBNumber" class="verdana" value="3902100000"</code>
My Excel file is:

A1 - https://erp.com/.../ro/product_detail.jsp?companyId=XXXXX&productId=YYYY
B1 - the copied 10 digit code from the macro/code

A2- different https://erp.com/.../ro/product_detail.jsp?companyId=XXXXX&productId=YYYY
B2 - the copied 10 digit code from the macro/code

and on an on until it gets to the last line (or a predefined row number...) which ever is simplier