Is there a simple, easy way to get a report that just has the links to the different sheets (using the Sheet Name column) that have been added to it?
I've done this before with my own sheets where I filter to something consistent in each sheet (ex., I use the ancestors and hierarchy in all of my sheets so I can just pull "Hierarchy 0" and I know it'll only pull the top row for each sheet).
But I have a request from someone else to make a "super report" that links to many other sheets across different workspaces in our company, and different people manage each of those, so I can't change their source data to make it consistent. He also wants the report to be dynamic so he can add new sheets anytime and it'll just keep an updated link so he can quickly and easily go to that data whenever he needs something.
Right now, it's 31 sheets with over 2,500 rows of data (more like 3,000), so grouping them lets me see the count of rows in each sheet, but I can't see the sheet names/links that way… but there is no consistency with text or topics across these sheets - it's just a list of sheets he cares about and wants access to.
… any help/ideas are appreciated!
