I can confirm that lookup table items should preserve the order from the spreadsheet.
Delete the content of the UID cells in all tables
What is this for? I’m not that familiar with managing lookup tables - I’d first try updating however you normally would, but with the order rearranged.
I uploaded the sorted look-up tables with the existing UID cells in place and the new sorting was not reflected in the look-up tables on the tablets. I will now delete the UID fields and hopefully this will sort out the problem.