I'm trying my best to learn formulas in Excel, but I'm struggling with understanding how to copy a formula from one tab to another within the same worksheet. The image below is a formula that a co-worker created for me that is quite lengthy, and I'm just trying to copy it into a cell on a different tab, but when I do I get a #VALUE! error message. I have no idea what to do with this.

Image 1.PNG

In this next image you can see that I'm getting an error message.

Image 2.PNG