Creating a pivot table using Macro

Hi,

I have a table of raw data that changes on a weekly basis and I want to be able to put this raw data into a pivot table as and when needed using a macro in order to speed things up. The number of columns remains the same but the number of rows changes continuously. (example attached).

Each time I record a macro and go through the steps one by one the macro stops and needs debugging at the stage of creating the pivot.

Can anyone help?


Thanks