I'm not sure what you're asking here:
If the source data changes you just need to refresh the pivot table (you may also have to adjust how far down the column the formulae in column AA).
Otherwise you can exclude certain ID nos. by filtering them out in the pivot table.


If I've misunderstood you question, come back.