Macro to Drag Down Formula

Hello,

I am trying to automate the "Sheet2" to have the formulas dragged down depending on the rows on Column A on "Sheet1"

For example I will be pasting work on Column A sheet 1 that might be around 300 lines. Sheet 2 formulas should be dragged down to line 300 as well with a macro.

By drag down i mean with the formulas too.
Attached a dummy workbook

Would appreciate any help

Thanks