HI everyone
a newbie and would like to
seek your advice on how to create a macro that is

-able to vlookup from a column and copies certain columns in a separate worksheet into a new worksheet"summary"(look up A and copy to B)
-using same reference column to vlookup from other two worksheets and copy into corresponding worksheet"summary" but in different columns (eg. C, D)
-do the vlookup till last cell(different each time)

Any help to kickstart will be most appreciated
Yours sincerely