Make pivot table dynamic...?

Hi,

I recorded a macro that creates a pivot table but just want to know how to make this part of the code 'Dynamic'

"Sheet1!R1C1:R913C21", Version:=xlPivotTableVersion12).CreatePivotTable _
        TableDestination:="Sheet1!R1C26", TableName:="PivotTable2", _
        DefaultVersion:=xlPivotTableVersion12

The R1C26 may change if new data is dumped in...

Please Advise. Ty