Update once, see everything. Excel dashboard, paste new transactions into tables, refresh pivots & optional Power Query ...
Don't waste time tidying up your spreadsheet manually.