How to split table?

RanzieJ 

Separate sheets might be easier because each sheet has a different formula and, also, one partial table cannot overlap the next.  The problem is that, in order to use recent methods, 2019 has to be removed in favour of using 365.  Then, the formula

= DROP(
    REDUCE({"",""}, UNIQUE(Level),
      LAMBDA(acc,grd,
        LET(
          headerRow, {"","","","";"Date","Name","Level","Amount"},
          selected,  FILTER(table, Level=grd),
          total,     SUM(TAKE(selected, ,-1)),
          totalRow,  HSTACK("Total","","", total),
          VSTACK(acc, headerRow, selected, totalRow)
        )
      )
    ),
  2)

will give

as a single output, with a bit of conditional formatting!