Cell reference different sheet changes when referenced sheet is sorted

I have a workbook with multiple sheets. One of my sheets is a"summary" sheet. It references cells in the "master" sheets. Sometimes I want the master sheets sorted by the date column, sometimes I sort...