Movie Rentals and Management

I am looking to create a template for movie rentals. One that is based off of one sheet, but has multiple sheets that keep track of movies that are out, and how long they have been out for, and who has them. So sheet one would have a menu(template) with drop downs of the movies, The Movie Film Rating and the Resident of an apartment complex that rented it out and a spot to enter what day they rented it....and then the lists or maybe a pivottable would work and update based off of data entered. So sheet two or the pivottable would show so and so has had DUMBO for 6 weeks......

Anyone have a template or know where I might get one, or could help me build one? Please any thought or sites or how to's or like I said the actual template would be greatly appreciated....

Thanks in advance!

I only have access to Excel on the property's computers while I am working.....and my laptop doesnt have Excel so no. Just seeing if I can get any creative juices flowing for tomorrow.

I did that as well and also found that. It is what I am starting with but I want something to show the person and the movie and how long they have had it for....as the property really has no limit but does expect common courtesy, and I want the checking out and checking in of movies to be down on drop down menu....with like warning saying that this movie is checkout already.....can Excel do that?!

Ugh I have a feeling I am going to be spending all day on this tomorrow if no one else can offer me anymore help or a template.....At least I got all the movies and titles and rating down....1787 DVDs and 282 Blu Rays.....so again anyone, any extra time or thoughts would be greatly appreciated. Just start really digging into Excel a year ago....so by no means a pro...