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!