Hi. Is it possible to set up data validation from a summary sheet that limits the list to information on another (referenced) sheet based on a cell in the summary sheet? For instance, if there are five detail sheets (ie, One, Two, Three, Four, Five) and a cell on the summary sheet has One, is it possible to show the list from data on the sheet titled One?

I’m not using tables because there may be 30-40 detailed sheets.

I can’t use VBA (organizational restriction).

If this isn’t possible, is there a workaround?

Thank you for any help or advice.