Copy and Paste last column onto another worksheet

i would say the easiest way is in cell J1 on sheet 1 use formula =sheet2!z1, then copy formula down the column ie j2 would be =sheet2!z2 everytime to update sheet 2 it automatically updates sheet 1

hope that helps

Nigel

thanks.
however, i never pointed out that new columns of data will be added to 'Sheet2' all the time.
Also, I will be repeating this process once a week.

Think I need VBA