Hi - see the example below from Superstore data
Sheet 1 is just sales by categor - sheet 2 is sales by subcategory - the action from sheet 1 to 2 then stays there
Set up an action filter - go to the top ribbon - select worksheet and then select add action - see below for the detail
and you get this
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.