Attempting to auto-populate cells with text and symbols

I create spread sheets for communications tracking for programs I write. I want to automate portions of the sheet to reduce, or eliminate, typo's.

I normally have an array of words for analog signals as well as digitals.

My basics are ME_2_YOU[0], I also have an array that sends my data (in Me_2_YOU[0]) to a foreign device, it is represented by MNET_X.WriteData[0]

I would like to have the array numbers, not always consecutive, stored in hidden cells and transferred into the [0] portion of the arrays.

For the digitals it is very simple and just a math function as it is an all numeric address.

I've attached a spreadsheet jpg to aid in discussion.