Create a pivot table that is based on a dynamic data source -- that is a range that adjusts automatically, if data is added or removed.

Are PivotTables interactive?

A PivotTable is an interactive way to quickly summarize large amounts of data. You can use a PivotTable to analyze numerical data in detail, and answer unanticipated questions about your data.

Are PivotTables automatically updated?

At any time, you can click Refresh to update the data for the PivotTables in your workbook. ... By default, PivotTables are not refreshed automatically, but you can specify that the PivotTable is automatically refreshed when you open the workbook that contains the PivotTable.