Lookup
 

I have a work sheet with a column of numbers, that are always being added
to.

I want use a different worksheet to lookup the last number in the column in
the first sheet.

i.e. vlookup last number in sheet 1 and place in sheet 2