Someone commented on the named range post - the data references need to be dynamic.

I use named ranges and cell references as I am building out sheets from scratch and later rearrange the layout to make it easier for others to use. However, every time I insert a row or column or move the data, the named ranges and/or cell references don't shift with the data.

Please fix this as the data loses its integrity the more the sheet evolves.