Search Bars and Data lookup issues in Movie Rental

So attached I have a preliminary thought process of what I am looking for. I want it to be easy to use and monitor and organized. So Sheet 1 you will be able to select a movie on the list in sheet 2 from the box on Sheet one.....kind of like a lookup tool. Then I want the rating to appear with that movie selection.....then I want the A/U to load to say whether the movie is available or unavailable......and then once we put a number into the apartment number...the date loads and it is labeled as rented.....

So heres the deal....I don't know how to do any of this....I don't know how to do the search box or the vlookup for the rating....Pivottables I am fine with....but I also want the menu on sheet one to update data in sheet two for columns C and D.....


Does this sound possible to anyone....Anyone at all....If you could please do some magic and see what updates that you can make it would be greatly appreciated.Movie Rental.xlsx