copy cell from a worksheet and paste to another worksheet

i have a workbook with 5 worksheets... on sheet1, i have 4 cells with values. what i want to do is to paste the first value to column 5 of second worksheet and fill down to the last row with value. copy 2nd value to the column 5 of third worksheet and fill down to the last row with value. i want to do this up to the last column.

how can i do this with macro?

i have attached a file for reference. Thanks!