Auto-filling from database

Hello,

I am sorry if this is a newbie question. I am trying to design a macro that will fill out a form by finding the information in another sheet. Right now, each row has an inventory number assigned to it and in a perfect world I would like to enter the inventory number in a given box on sheet two, start the macro, find the rest of the information on sheet one and fill the other information such as serial number, model number and the such back on sheet two.

So far, I have been able to get the macro to fill in the information, but the missing link seems to be actually finding the right row to get the information from. It keeps copying the information from the same row, no matter what inventory number I but in the box.

Thanks