Create Autofill_data across columns and sheets

the macro can be used to apply changes like copying formulas, values from the first cell of the column and apply it to the rest of the rows in the column. The last row is determined by finalrow.