MACRO Reference multiple cells that have values that differ from each sheet

[Aseagz15]

At work I have a URL that has multiple parts, and I am able to reference specific cells in each sheet in my excel workbook. Some parts of the URL are the month, year, account, and the specific report type I would like to access.

I have created a hyperlink that takes me to our company website and to a specific report. The following is what I have (I have substituted the website name).
=HYPERLINK("https://examplewebsite.com/example?cmd=new&unit=01&action=balsht&yearin="&YEAR($A$1)&"&monthin="&MONTH($B$1)&"&account="&$C$1,$C$1)

The balsht is for balance sheet, that is the specific report I am accessing with the hyperlink. Other reports are sumrev (summary of revenue), detail (journal detail), etc.

I would like to click Ctrl + Shift + S to open a macro that will reference cells in each sheet (my spreadsheet has about 20 different sheets but the year, month, and account are in the same cells on each sheet). I would like the macro to open a pop up menu with different buttons labeled "balsht", "sumrev", "detail", etc. When I click the cells I want chrome to open a new tab that will open these specific reports on our company website.

This is hard to explain, I am an accountant but I am trying to make our spreadsheets more user friendly.

 

[Fluff]

Duplicated https://www.mrexcel.com/forum/excel...ive-worksheet-part-hyperlink.html#post5023024

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).

If you do not receive a response, you can "bump" it by replying to it again, though we advise you to wait 24 hours before doing and not to bump a thread more than once a day.