I am trying to build a quotation package as follows, and could do with some
(lots) of help trying to get it working

I have an excel book with a number of sheets (PRICES), each sheet contains
the item number and in the adjacent cell the price.
What I want to do is enter the part number in the quotation page, then have
a macro go and lookup (PRICES) to find the item, then return the value in the
adjacent cell. This should continue until it reaches the end on the items to
be priced. Note that the item could be in any one of 4 sheets, but will only
appear once.

I am new to VBA and totally lost, any help at all would be good

Thanks