Excel 2007 VBA - Use VLOOKUP to find value in different worksheet and store result in active sheet

I am new to this group and VBA.

I have a worksheet 'T2', with a variable number of rows. Starting with row 3, I want to look up the item number found in column 'E' and search worksheet 'Support'. The item number can be found somewhere in column 'A' in 'Support'. I need to bring the value in column 'B' in Support (that relates to that item number) and store it in column 'A' in worksheet 'T2'. I then want to repeat this process for every row in 'T2' up to and including the last row.

Can anyone help please as I just can't get this to work at all.

Thanks