For named ranges that are an array, you can use =index(array,#) to create a dynamic list. For example, on the spellcasting tab, if you put =INDEX(SpellListLevel1,1+AI16) in the first level 1 space and copy/paste formula to the rest of the list, you will have a dynamic list of spells to chose...