Macro to pull data as a Vlookup

Hi everyone

I was wondering if anyone can advise me on the possibilty of running a macro will do a vlook up to include the last line of data on a spreadsheet and also pick it up everytime the lines of data increases?

Any help will be very much appreciated.

Many Thanks,

T