Create a button to run multiple hyperlinks?

In my workbook i have formulas that add segments together and convert them into hyperlinks. The goal is to create a driving distance calculator based on two points. for example. i have a job site at XXXX Riverrun lane. but there are two nearby vendors that sell similar products. the cheapest vendor is a bit further away.

The study will aid in determining the most cost-effective method of obtaining the merchandise.

i have approximately 30 hyperlinks i would like to divide into regions for the purpose of bidding jobs. these hyperlinks will automatically update, depending on the job site coordinates i initially input. because of this i will not be able to create a macro with a stated address. the macro will need to read the cell's information and execute the hyperlink command.

my goal is to have a button execute around 7 hyperlinks upon clicking it. i believe i have added an attachment to this thread, however i am a new user to this form and may have not added the attachment .png correctly.

thank you for looking, and thank you for the help!