to cut a long story short... have you considered the benefits of using a
MS Access database instead?

I think it would be infinitely simpler in this instance (one record per room
in a table(s) etc).

Access could handle this in a single form  very easily.