My advice is, instead a sheet, where you have data organized as you want to read/print them, used as data entry sheet and source of calculations, have separate sheets for those tasks.

Data entry sheet will have a single table, where in addition of current columns you'll have additionally columns for date and shift (as 2 leftmost columns).

On report sheet, at top you can have data validation lists to determine report conditions, and then there is/are report table(s) designed in a way you like them, where all table values cells are calculated from data entry table according to selected report conditions. The number of different report sheets is not limited (you can have daily reports, or weekly/monthly/yearly reports, or whatever. And you don't have to use the same design for different report sheets (but you can).

The main formulas to get any numeric info (both entry values and summary info) from data entry table to report(s) will be SUMIFS(), and probably also COUNTIFS(). To get any text info, you need a hidden column in data entry table, where all rows of data entry table are numbered (=ROW()-ROW(SomeHeaderCell). Then you can use SUMIFS() to get the row number for wanted info, and use INDEX() formula to get wanted info from proper column and row. As you see, with such design all used formulas will be relatively simple ones!