Okay, after going back and looking more closely I realized what was happening. For some reason Excel put the full address (C:\My Documents\.... etc) before the tab it was supposed to be referencing. Once I went through and deleted all of those it works perfectly.

Again, thank you SO much for the help anyone. I really appreciate this!