Hello,

I've heard of dynamic named ranges but is there something to automatically
insert the name of a newly added worksheet in the named range?

My excel file has 200 worksheets and is expanding. I've created a dynamic
name range to use as a reference to my drop down menu for easy access to the
worksheets. But I'm tired of manually adding the newly created worksheet
name to my dynamic list.

Please let me know if this is possible.

Thanks for looking,

MJ
--
Thank You!