Council of Dawn Script for Google Sheet for u/FloppyDingo24. Reddit Request : https://www.reddit.com/r/programmingrequests/comments/bnz8pg/need_a_javascript_google_script_to_hide_and_show/

sort_classes.gscript

function myFunction() {
  var ss = SpreadsheetApp.getActiveSpreadsheet();

  var classes = [
    "Character Sheet",
    "Marauder",
    "Warrior",
    "Dark Knight",
    "Gladiator",
    "Paladin",
    "Conjurer",
    "White Mage",
    "Arcanist",
    "Scholar",
    "Astrologian",
    "Pugilist",
    "Monk",
    "Lancer",
    "Dragoon",
    "Rogue",
    "Ninja",
    "Samurai",
    "Archer",
    "Bard",
    "Machinist",
    "Summoner",
    "Thaumaturge",
    "Black Mage",
    "Red Mage",
    "Garlean Pureblood",
  ]
    
  var sheet1 = ss.getSheetByName(classes[0]);
  var cell1 = sheet1.getRange('B5');
  var cell2 = sheet1.getRange('C5');
  var cell3 = sheet1.getRange('D5');
  
  classes.map(function(value){
    console.log(value)
    var sheetOption =  ss.getSheetByName(value);
    
    if (cell1.getValue() == value || cell2.getValue() == value || cell3.getValue() == value) {
        sheetOption.showSheet()
    } else {
        sheetOption.hideSheet()
    }
  })
 
}