#REF! notification while refering to another worksheet on excel

While trying to link 2 worksheets on excel with one another, I keep getting a #REF! output on my cells on worksheet 1 that are refering to the other worksheet (2). This only happens when I close the ...