Glenn, I appreciate your patience with me. So what you're saying is that in the example you provided, Book2, when I create new sheet the list of sheets in column AA should be automatically updating? Its not working for me. And I definitely have macros enabled.

I'm sure there is a way for me to create a VBS to make a dynamic list of sheet names that populate there, so you've definitely got me on the right track. Many thanks!