Combining dynamic array functions

I am amazed at the lack of internet help on this subject. I have searched high and low for detailed pieces about the syntax of combining more than one dynamic array functions, specifically for my needs, the SORT and FILTER functions and the SORTBY and FILTER functions.

I need to be able to process a table of data and both sort it by a number of columns but also filter either multiple values from just one column or values in multiple columns.

Can anyone help me learn how to do this? I understand the basic syntax of the SORT, SORTBY and FILTER functions; it's the combining of them that is eluding me and there's just almost nothing out there to help.

I am attaching a sample file that I've been experimenting with.

Many thanks.



Andrew