Auto-Refresh of Pivot Table when Data Set is Changed?

You need to set up a change event in VBA on the page that contains the data source table. That's all I can provide without actually having a sample workbook.

If you are using an actual Excel Table, you can empty it of all proprietary data and throw in sample data. The code can be copied back to your original sheet and it should still work.

a pivot table based off of this table in another sheet

a change event in VBA on the page that contains the data source table.

I think you can also make a VBA on opening the other sheet.

Good Idea, @popipipo: an On open event of the sheet that contains the pivot table is a cleaner implementation. The user can make multiple changes in the data without running any code and then the code is only run when the pivot table sheet is activated. Thanks for suggesting it.