I have 8 "tables" were tables, that I converted back, on one worksheet. Each table has a team of names. Those names change periodically and I like to keep the list of names in AZ order but the cell fill color goes with it.

You can copy and paste, drag and fill and just about everything else without formatting, but I can't figure out how to sort without formatting.