Help On Array Loop

Hi, I'm trying to read from one excel sheet and write the same data to another excel sheet, below is the code what I wrote, but I'm unable to write all the data to the target sheet... only last...