Peo Sjoblom wrote...
....
Pivot tables are probably the fastest way to go if applicable
....

Except for the fact that Excel doesn't regenerate pivot tables as part
of automatic recalculation. Syncing pivot tables is a manual process.