Excel dynamic range update for pivot table
This video shows how to update a pivot table with its source data range being subject to frequent changes and refreshing it without manually adjusting the data range for each change.
Due to security concerns I am not able to place this on my site so unfortunately this is not a downloadable file but if you like you can take a screen shot of the VBA module to replicate after tweaking for your needs.