Make a traveling Pivot table

I've attached a mockup of my worksheet. In one page I'm trying to have all my source data on the left, and my summary pivot on the right. It all works well, except that I keep adding lines to my data, so I'm going farther down, and my pivot is stuck way up at the top.

Here's my question: Is there a way, other than cutting and pasting it where I want it today, to have my pivot always close to the bottom of my data?

Hi,
there's a button for it on the analyse Tab called Move PivotTable,
but I have made another button for you:

Please Login or Register  to view this content.

Cheers
Erwin

Hey Eastwood,
Thanks for the code. I had created almost the same thing, but your code is more elegant than mine, so went your route. However, I didn't do a button, but instead put it in the "Worksheet Activate" event. I add lines every day, but usually no more than 5 or 6, so as long as the pivot is in the neighborhood I'm good. Thanks for your help![