Drag number 1 sheet to another sheet.

Hi,

I am trying to drag drag number with specific quantity from one sheet to another sheet,
1) There is item name in col C ,start number in Col D and dragging qty in col F
2) i want start 1 item drag in sheet 2 with quantity in sheet 2 col D.

The data is near about 20 lack so is it possible with Macro code or any formula.
any help really appreciate.

I have attached sample workbook with input and output result.