dynamic table and columns

Hi 

I have a dynamic table in excel. It keeps changing every month.
It has columns of all weeks. The columns keeps changing every month.
I want to display the data of latest 4 weeks  and 8 weeks.

I want to display data of last month. So December’s data in January...then January’s data in February and so on.

So I have created table visual. Inserted 4 columns of 4 weeks .Then 5th column as sum of 4 columns.
How do I display it on table visual so when the column changes , it automatically updates on visual.

so basically we need to change column names on table visual while refreshing columns on table in Exccel.

Please see the attached report. I want to display this type of report on table visual.

waiting for the best solution......

Thanks a lot