adding columns to a linked worksheet to sort with worksheet

I am experiencing this same issue. I am new to the Office world.  I have spent the past decade working with Google.  Google spreadsheets intuitively sorts data correctly across sheets and files, because there is a need sometimes for different sheets. There are other features that Google Sheets seems to have, freezing multiple columns and rows for example, that doesn't seem to function the same in the Office world, at least the cloud world. Again, I am new to the Office world so maybe I am missing something; however, I feel, the intuitivity of Office needs to be elevated in this area. Highest requesting of feature.