macro with a pivot table where data is constantly added

Hello,

I want to build a macro that produces a pivot table where the reference table is constantly changing.
Now the question is, how can I "make" the pivot table pick up data from a table that doesn't always have the same number of lines ??

your help is much appreciated
thank you
Marius