ForgedAnvil
Explorer
Nope. It can be done only with for Excel Formulas and drop-down lists. But yes, these formulas is very monstrous.
*sorry for mistakes, English isn't my native language and i can't say i know it very well.
The idea is to keep the cells in the Gear section as editable (unlocked) to allow users complete freedom on what is written there, hence a macro would be needed to "copy and paste" a list of gear to the Gear section as text only that can be edited