Dynamic sorting
 

Is it possible to have an area in one of the spreadsheets that is always
sorted according certain rule and to make changes in the other spreadsheets
and that any change will be affecting the sorted area