Right? I work with plenty of users in non-technical roles who have at best rudimentary Excel skills, and even they could figure out a better way to manage this. The whole thing with Excel is to make basic data work accessible even to a rube, and let them do an incredible amount of things otherwise outside their skillet.

Using Excel like this is like giving someone a pressure cooker and they only use it to boil water.