Without delving into macros & code, try investigating the Custom Views feature of Excel (see under the View menu).

This allows filtered lists to be preserved, saved, and named, so that a different presentation of the data is available to different users by them selecting the custom view required.