To be honest in the begining of the project  I was thinking the same
as you, but the client wants to see a visual rooms as well whenever
they wish so for that reason I had to create  a single sheet for each
room.
If I cannot find a solution for this problem, then I am going to
create a main page  for the all rooms and put a 40 command  button
with the Check-in lebel and create a 40 user  form for every each
room...I don't know this sounds bit silly but that's all I can do...