I used Sheet1 as the data source to create a pivot table in a new worksheet
which I named Sheet PT.

Is it possible to design the workbook so that I can delete the data in
Sheet1 and then paste new data with more or less rows in Sheet1 and have the
pivot table in Sheet PT update to reflect the new data that has been pasted
into Sheet1 but the formating of the pivot table stays the same?