Excel VBA Macro To Dynamically Change Source for Pivot Table

[Howardc]

I have a spreadheet with a sheet named "Pivot table" and a sheet named "Import" Data"

I use a macro to import the data and to total and age the data on the sheet "Import Data" The macro works perfectly

I need a macro that will change the Pivot Table Data Size from A1 to where the last value appears in Column L. However, text "Total WIP" appears in Col G three rows after the last value in Col G and the total value appears three columns to the right of this

I have attached a sample


Your assistance in this regard is most appreciated