Excel's Power Query lets you build report-level and table-level timestamps that update on refresh.
Excel has quietly gained dynamic arrays, XLOOKUP, Power Query, and Python, yet many still work the old way.