Apply Current Filter Settings to the Entire Workbook

You can apply your filter settings to your entire workbook

Now your current filter settings have been applied to all sheets in your entire workbook

You can also apply a Reporting Date of your choice to your entire workbook

Now your Reporting Date has been applied to all sheets in your entire workbook