Macro to copy and paste rows until blank comes

Hello,

Can anyone help me to write macro code for the below condition.


I have data sheet which updates on a daily basis and no. Of rows with records will be increased.
I have other reference sheet with one row of formula built in.
Here I wanna update my reference sheet I.e, copy the entire built in formula row and paste until the row count of main sheet criteria met.


Thanks & Regards
Emmanuel