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 them by the customer, etc. When I sort the master pages, the summary page stays referenced to the absolute cell it originally referenced and does not follow the intended cell that moved when it was sorted.
Is there a way to make the summary page references follow the cells on the other pages as they move when they are sorted in different ways?
Thank you in advance.
