For such projects all data should be stored on one sheet in a table layout - a header row, no completely empty rows or columns. Then use PivotTables or AdvancedFilter etc