Updating pivot tables automatically when leaving worksheet. Specific occurances only

I have a spreadsheet with multiple pivot tables all reading from one source. The source is on the tab "Waiver List"

Each pivot table is on a separate tab within the same workbook.

Currently, I have a code on the "waiver list" tab that updates all pivot tables whenever I leave that sheet. There's also a code that sorts the waiver list whenever I go to that tab.

Here's the 2 codes:

Please Login or Register  to view this content.

What I WANT to do is to ONLY update the pivot tables when I leave the "Waiver List" tab AFTER/IF any changes are made. So if I just select the sheet, it sorts, but I don't add any new information, or change and data, I don't want the pivot tables to all refresh.

Now, maybe this can't be done because it will read the sorting as changes being made, but maybe someone in here can help me out.

I'm not a VBA pro, but I understand the general terms. If you need other information about the sheet let me know.