Macro to list pages with shared labels and a condition

[Deleted user]

Any ideas on how to accomplish this? Or suggestions on a custom macro?

Scenario

• Shared Links
  • USGS Earthquake Map
    • Label: shared-links, category-meteorological, meteorological-earthquake
  • Typhoon mapper
    • Labels: shared-links, category-meteorological, meteorological-earthquake
  • WSJ Reports
    • Labels: shared-links, category-strike, strike-labor, strike-union
• Standard Operating Procedures
  • Meteorological 
    • Earthquakes
    • Typhoons
  • Strike
    • Labor Strike
    • Union Strike

I have a page in confluence where we store shared links that are resources in physical security events. We have a common taxonomy for each category and sub-category of SOP that matches the page names above.

I would like a macro that lists the pages for a shared link that also has other common labels.

For example:

On the Earthquakes SOP it would show the USGS Earthquake Map page because it has the label: "meteorological-earthquake"

On the Meteorological SOP it would  show the USGS Earthquake Map and Typhoon Mapper page because they both have the label: "category-meteorological"

The reason we don't want to use the "Content by label" macro is because I want the macro to find pages with the same labels as the current page that are either #1 using a specific label "shared-links" or #2 have a specific parent "Shared Links"

Any ideas, or suggestions on creating a custom macro?