Macro to sum the cells left of the current week number

Hi

I would like a macro to insert a column to the left of a current week number and sum its values to the left from column E. For example the macro would select the week number based on current date (currently week20) and then insert a column to the left and sum its values from column E to the inserted column. Please see the attached spread sheet for more details.

Any help would be greatly appreciated.

Many Thanks
Hoss