I’ve seen issues, in particular rollup columns, that didn’t work when a relation column was rename. Maybe this was part of that issue.
What I would do is create a sheet that lists all of the different classes and maybe some info about the class. From there you could create a relation to the Fleet Details sheet. I know you currently have the 350 Details sheet, but it may be better to design this to hold details for all classes, so you don’t have to redesign the details for separate fleets. Without have a full visual of your data structure, it’s hard to say exactly how to set this up, but I would think it would be pretty simple using the right relations. I’d envision it something like the multi-level select in https://concepts.glideapp.io/.
I would consider looking at the new Enhanced Link to Screen action if you want to use a button. 🔗 Enhanced Link to Screen Action. You can refer to the same row of data, but design the screen independently.