Data source selection for Pivot table refresh

[Prithvi_P_M]

Hi Team,

I am trying to refresh an existing pivot table whose data source is in a different tab. The number of rows in the data source are not constant and can change. How do i change the data source to select the complete range before refreshing the Pivot table.

I do not have any coding experience and would highly appreciate any inputs on the above. Thanks in advance for your help.