Update once, see everything. Excel dashboard, paste new transactions into tables, refresh pivots & optional Power Query ...
One reason people hesitate with LAMBDA is the assumption that it requires learning something entirely new. It doesn't. Every part of a LAMBDA function is made from regular Excel formulas. If you can ...