Unfortunately, Excel does not natively offer a feature to automatically refresh all the detail views (drill-through sheets) generated from a PivotTable. However, you can automate this process using VBA. Below is an approach to refresh all detail views using VBA:
Steps to Refresh All Drill-Through Detail Views with VBA
Clear Old Detail Sheets: Write VBA code to identify and delete existing drill-through sheets.
Regenerate Detail Views: Automate double-clicking on the appropriate cells to regenerate the drill-through sheets.