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!

Hi DaddyC. There is no attachment on your post. Please post your excel file so we don't have to recreate everything in order to work on this. So what determines what 7 hyperlinks you will want to run when pushing the button?
-Squeaky