Unfortunately, none of those achieve the behavior I require.
Option 2 - Keeps the entire dashboard filtered to the last date but doesn't allow for the user to navigate between dates (they are all filtered out).
Option 3 - I can only apply this to one sheet, I need a solution to apply to the entire dashboard.
Option 4 - Doesn't work.
and I suppose that you don't have a workbook to paste here :-)