Macro for ’Auto Fill’/Copy down x number of cells

I have a worksheet with source data with a number of rows and columns (of cource).
I have built a macro which create a new worksheet in the same workbook and which recalculate the values in the first line (into new values in the first line in the new worksheet).

When this is in place I want (the macro) to autofill/copy down the values the same number of rows which is in the source sheet.
What would that macro code look like ?
I would like to build in that macro in the macro I already have in place.

Saturn