Update data linked between worksheets when resorting data

[JayStar]

I refer to certain cells in a different worksheet (same workbook). When
resorting the main worksheet, the data does not update in the associated
worksheet. It always used to in previous Excel versions. What do I need to
do?