In the Confluence Administration, in the vertical left menu, click Macro Usage.
This will open a page that displays which macros are in use and the number of pages on which they appear:

Note
This works for Confluence on-premises and Confluence Cloud.The link to this page is admin/pluginusage.action
(on-premises) or admin/macro-usage
(Cloud).
Clicking on any of the macro names opens a search results page showing pages that use this macro.
The link for this kind of macro search is dosearchsite.action?cql=macro = "aura-tab"
(here searching for the aura-tab macro).
Feel free to provide me with this list, e.g. for a demo or just for informational purposes.