Creating a macro to open multiple formulated hyperlinks

Good evening all,

I'm a Excel beginner and I'm trying to create a spreadsheet to help my office out. We have a searchable intranet web page. With the spreadsheet, you can enter up to 50 phone numbers, which will remove any special characters and breaking the number down to the area code, the next three digits and the last four digits. After breaking the number down, I created a hyperlink that takes the intranet search url and adding the broken down number. The cell formula looks like, =HYPERLINK("http://xxxxxxxxxxxxxxxxx" & B1 & "xxxxxx" & C1 & "xxxxxx" & D1, "&B1&""&C1&""&D1&"" which when clicked will direct me to "http://xxxxxxxxxxxxxxxxx888xxxxxx555xxxxxx1234". I want to create a macro that will, after populating Columnn A with 1-50 phone numbers, open with 1-50 different tabs with the different search results. I've tried many different options, and I think through trial and error, hyperlinks().follow will not work because the hyperlink is formulated. Any help would be much appreciated. I can add more details if needed. Thanks!

Any help, even just throwing thoughts out would help, Thanks!

Thanks for helping! I tried that macro and it worked...sort of. When clicking on the macro, a new tab opened with "http://xxxxxxxxxxxxxxxxx". It is missing the rest of the hyperlink (broken down phone number and the search jargon).