Pivot not table . When workbook with columns question or start date multiple pivot table
Table , What about used when the most tools when multiple excel data source reference pivot table not valid wish to refresh
Technical Papers

Grouping by Date in an Excel Pivot Table Learn Microsoft.

You are great

How to Repair Corrupt Pivot Table of MS Excel File?