To keep an NHS dashboard up to date, start with what the source system already produces. If it can deliver an approved export, agree where the file will arrive, which sheet holds the data and which columns the dashboard needs. At the estates handover, that might mean a single list with job reference, site and status. Confirm whether a blank list means there are no open jobs or the export failed.
If one maintained workbook already serves the team, a refreshable Excel connection may be enough. Power Query can bring updated data into an existing workbook, and supported Excel connections can be set to refresh when the file opens. That still depends on the source being available. Microsoft’s guide to refreshing data in Excel.