I am working on a Key Dates sheet in Google and trying to set up different tabs with different department key dates, then use the Filter function to pull data from all tabs into the main tab, based on a condition (is a box checked).

I am using “=FILTER(AwardsDates,Awards_Key_Dates[Insert in Key Dates?]=TRUE)” which works for one tab, but I can’t work out how to adjust this to cover all other tabs. Spreadsheet is here: https://docs.google.com/spreadsheets/d/1gVocWTavcNS9XGHjSpt7Zrzi19YCPI0jxq2Xr07tp9o/edit#gid=1321993176