I've figured it out. In case anyone else needs this help... because I'm on a network I couldn't just name the sheet with the sheet name, I would have had to include the network path to it as well I believe. So what I did instead to get around this was:
- named the range on the Test Sheet
-...