Trying to add from one sheet to another without clicking on each cell.
EX:
Sheet 1 Cell A1 = Sheet 2 Cell A1
Sheet 1 Cell A2 = Sheet 2 Cell A20
Sheet 1 Cell A3 = Sheet 2 Cell A40 etc etc.
How can i do this, to drag down on sheet 1 so I get the above results on
sheet 2.
Is there a formula to add lines not quantity?

Thanks