Dash update on daily basis with macro

Hi Guys,

I have attached a excel sheet to which i need a macro.

I am updating this dash board on daily basis.
daily i need to insert rows, columns as per date.
Here i need a macro that should insert a column after 9th row, after 'e' column.

And when i run a macro graphs should update rows & columns which we added, as i taken in the excel file.
and sum formula also should update the rows and columns which we are adding with macro.

i need blank cells to update with numbers


Thanks,
PRB

no one is helping on this....

can anyone solve this....

PRB