Finding values from 2 worksheets where item matches

Hi,
I have just start my new role where I am stuck some where
I have got 1 Order form where
SUPLIER NAME|SUPPLIER CODE |SUPLIER ITEM CODE|REF NO|ITEM CODE|DESCRIPTION
its full of data and I need to search of an 'Supplier Item Code' and against this I want to find the Ref No. where There is another work sheet of atleast 5000 products with Item code and reference number.I want all of the reference number to come on the 1st worksheet where it matches Item code.
Thanks and Please help me.