I have enclosed a basic version of the sheet I would like help with please.

GCA.xlsm

On sheet 1 Floors, I would like to have a button that could sort the columns of data by room (bed) number ascending.
But on the second and third sheets there is supplementary information that would also need to be sorted at the same time accordingly. On the 2nd and 3rd sheets (6th floor and 5th floor) the bed number and name are linked from the first sheet and protected.

I don't know if this is possible. I have very limited coding knowledge and would appreciate it if any experts out here could write this if it can be done easily.