Are you planning on allowing users to enter data directly onto the spreadsheet also?
If not, you don’t really need to worry about cleaning it up too much - it’s your own design playing out.
If so, then create a single ‘entry’ sheet that is styled to 1) help users quickly fill it in and 2) distribute inputs across your other sheets as it’s filled in.
Then you can simply protect and hide all the other sheets so users only ever see the single sheet they need to deal with.
You can use single tab in sheet. and Use Relation column to remove redundancies of the data. With relation you can set more than one categories for each animal too.
Yes I’m using relations between shelters and animals. But for the home and search screen, I didn’t know how to display like this without creating multiple tabs.
At the beggining, I had one tab for all shelters and I created columns for ‘categorie 1’ ‘categorie 2’ ‘categorie 3’, etc. (because some shelters have 3 categories). But, it was not possible to display all categories like what we see right now.
I also made a quick sheet demonstrating a simple table… you can also get a little tricker and import data from other sheets using IMPORTRANGE (as demonstrated in Sheet3).