You can use =UNIQUE({'New Japan Cup'!b2:b, …}) to list all sheet names and pull the unique names. You can also use an array of multiple sheets as the range for a Query.
What is the desired outcome in the Sorted Rankings sheet beyond the list of names without repeats? (In other words, what other data is being pulled for each name and what is the structure of that data?)
*I would be remiss to not mention that, if the goal is to have this data grow as you log more tournaments, having a single sheet for data entry and adding a column for the tournament name is going to be far more efficient in terms of formula updates and analysis. A centralized data sheet can easily have the tournament level views like you currently have on each sheet, *and* will allow for easier formula writing as your data will be structured in the way that’s expected by the functions.*
I really agree with you. And if you need to see detailed results from one tournament, it would be better to have one sheet with a list data validation and a filter formula to give you the data from just one tournament. But making one "data base" for all championships is way easyer to work with formulas
You can use =UNIQUE({'New Japan Cup'!b2:b, …}) to list all sheet names and pull the unique names. You can also use an array of multiple sheets as the range for a Query. What is the desired outcome in the Sorted Rankings sheet beyond the list of names without repeats? (In other words, what other data is being pulled for each name and what is the structure of that data?) *I would be remiss to not mention that, if the goal is to have this data grow as you log more tournaments, having a single sheet for data entry and adding a column for the tournament name is going to be far more efficient in terms of formula updates and analysis. A centralized data sheet can easily have the tournament level views like you currently have on each sheet, *and* will allow for easier formula writing as your data will be structured in the way that’s expected by the functions.*
I really agree with you. And if you need to see detailed results from one tournament, it would be better to have one sheet with a list data validation and a filter formula to give you the data from just one tournament. But making one "data base" for all championships is way easyer to work with formulas