Copy formulas from the Source worksheet to the Target worksheet using a macro

I am trying to copy formulas from the Source worksheet ("Date Range") to the Target worksheet ("Staffing"). The formulas in the Source worksheet are in columns (V5 through AO5). I want to copy the formulas to the Target worksheet to rows A1 through A20. Below is how the data should look in the Target worksheet. I would like to have a macro that copies the formulas automatically to a specific range in the Target worksheet.


Target Worksheet Data:
A1: "='Date Range'!$V$5"
A2: "='Date Range'!$W$5
A3: "='Date Range'!$X$5
A4: "='Date Range'!$Y$5
A5: "='Date Range'!$Z$5
..
..

Any guidance on how to write the macro would be appreciated. Thanks!

- Ron -

Thank you Alansidman and Vikas_Gautam, the code worked great. I appreciate you time and help on helping me with this problem.