My guess is that you have additional filters on the 4a-4e sheets which are preventing the action filter to work. I'd say select something from the 1c sheet on the dashboard then go to one of those 5 corresponding sheets. Start taking off filters one by one until you find the one that is preventing you desired outcome.
Just check that you have right target data source because you are using selected fields.
Tableau is strange. Your suggestions didn't change anything. What I did to solve for this was removing the actions that didn't work and re-creating them. For some reason, I had to adjust the settings in the action in this order or it did not work:
- Source Sheets
- Target Sheets
- Clearing the Selection will
- Target Filters
- Run action on