Moving data from one sheet to another.

Hi, I'm a new user to Excel and I need to know if there is a way to get information from one sheet into another. I have a sheet with part numbers in one column and their respective prices in the next. I would like to be able to enter the part numbers on another sheet and have the price put in automatically. I really am an IT virgin so I hope it isn't too difficult.

Thanks