Web query a list of URLs and result with data from each on its respective row.

Example file attached.

I have about 3,000 transactions stored on a website. There's a different page for each transaction, and the URL is always the same, except for the transaction ID at the end. e.g. //same.same/same/different

In Excel, I have a list of transaction IDs. I want it to query the site and put the data for each transaction on the row with its transaction ID.

The part that remains the same is as follows, but without the underscores in the middle (it's password protected, sorry):
brikrealty.backagent.net/transaction/detail/snapshot/?

Transaction IDs look like these three examples:
e734782e-76e4-49dc-a3b0-5484ab0429d0
b37c3e44-5cb7-439f-91ee-689943a70417
0ef713c0-12b4-47e3-96f5-e964263b3952

So, the page for the first transaction is: brikrealty.backagent.net/transaction/detail/snapshot/?e734782e-76e4-49dc-a3b0-5484ab0429d0

I want to have something like the following, where the column labels and amounts are pulled from the web pages:

Transaction ID	Label 1	Amount 1	Label 2	Amount 2	and so on...
e734782e-76e4-49dc-a3b0-5484ab0429d0
b37c3e44-5cb7-439f-91ee-689943a70417
0ef713c0-12b4-47e3-96f5-e964263b3952

The site requires lon-in.