I have ten rooms that need to be kept stocked with pamphlets (about 25 different pamphlets, some could be added or removed in the future). I want to keep track of how many pamphlets remain in each room, how many I remove because they are tattered, and how many I add to replenish the stock. I gather these data on a weekly basis.

Right now I'm using a chart with room numbers along the y axis and pamphlet titles along the x axis. Each cell in the table has space for the three numbers I mentioned previously. I print a new copy each week and fill it in by hand as I visit each room.

I'd really like to create a spreadsheet to store the historical data (the goal is to identify trends in the popularity of various pamphlets so we know how many and how often to order more). In my head it's just a 3D table with the three axes "Room #", "Pamphlet Title", and "Date". I could create a separate sheet for each room or for each sheet to achieve three dimensions, but data entry wouldn't be pleasant. The best would be if I could just create a new sheet each week, but that leads to an ever increasing number of sheets, and that just doesn't seem like good design.

I've started to create an Access database, but I was running into structural issues there as well (namely, adding or removing pamphlet titles would require redesigning forms and reports - not an elegant solution). I'm hoping someone here might have some thoughts that will lead me to a solution. Thanks.