Lets say you have two separate worksheets

Sheet1 has your data

Sheet2 has your pivot- on that data from sheet1

The issue is this,
When I change the data on Sheet1 (It's Usually more data; more rows) It can still lead to me having the incorrect information on the Pivot Sheet (Sheet2) because I usually have to
manually go in and change the 'Source Data of the pivot table.

Is there a work-around to this using a Macro?

Please Advise