I think you could still show a visual listing of the rooms without
having 40 sheets, or 40 buttons. Take a look at setting up a user form
that will select the room for a combo box, and then perform an Advanced
Filter on the button click. That way, you can filter out the other
rooms, have the data in a better format for manipulation and still meet
the client's needs. ?