Auto Update Pivot Table

[ceejay01]

Is there a way to automatically update my pivot table whenever there is change in a worksheet.

I have a sheet name "search" which will change date and data every week. Is there a code to update the dates and data in my pivot?

Please suggest.

Thanks