Column A,B, C, D are populated during refresh but column E is calculated column for instance =(B/C)

what the best way to trickle down the formula to new rows every week automatically instead of opening the file and copy paste

the formula to new rows and in column E

thanks