It's late and I've been working on this for a while, I had a version of this working on another google sheet, but in that one I was only trying to work with one sheet at a time. This time, I'm trying to call ranges from multiple sheets and I think I'm just doing it wrong... I appreciate any help, but no matter how I try to arrange this I keep getting "Cannot read property 'getRange' of null like I'm calling absolutely nothing. :\

Edit