im using DEREFERENCE to populate information ...

[Francisco_Marti]

im using DEREFERENCE to populate information from SHEET1 to SHEET2, but it seems that when I make a change to the information to SHEET1 it doesn’t change and reflect on SHEET2.

is there an alternative to REFERENCE to solve this issue?

thank you;