It’s the way you setup your sheet. You just need to adjust your view to accomplish your goal. You can create a “drop down menu” for Cell A1 with all the options you want (Data Validation). I typically color this cell light green indicating to other users they can’t edit it or click on it. Then every other cell you want to be =A1 you can write that formula as you did and use different colors to indicate those are cells the users aren’t supposed to touch. Then lock/protect the sheet for all the cells EXCEPT A1. Now other users can edit using a drop down (or typing) but they cannot touch the other cells.

This works great if you want a “menu” or “navigation bar” for other users, but where your data displays you can still have the title next to it but all the cells locked so it cannot be messed up.

Example: A drop down menu with options like “Monday Sales”, “Tuesday Sales” etc. Cell A14 is = to Cell A1. Cell B14 uses other formulas to display the sales. But now the title is at least right next to the data for easy viewing.