What have you tried so far? Action filters are demonstrated in the online learning tutorials that cover these sorts of examples here: Dashboard Interactivity Using Actions
If you are still needing assistance, please upload a Tableau workbook (.twbx) file with some sample data to show us what you have tried.
I'm not sure, what your required and not understood what this mean.
Note: Please provide the solution both the sheets should come from single data source and both are from different data source also.
Share your workbook for better assitance.