Action filters will work well if your reports are related to each other .
Looks like you just want users to select a particular report , In that case you can make use of below
Please mark the answer as CORRECT & HELPFUL if it helps you
Is it possible to create sheet selector if we have different sheet from different data source..?
Yes it should work, please try and let us know.
I have uploaded a video to my channel as well Dynamic Sheet Selection-Tableau (Reprise short version) - YouTube
If it helps kindly mark the answer as CORRECT & HELPFUL so that it can help others as well