How do I get data from the 'Statement' sheet to automatically sort into the 'Expenses' sheet?

Question

https://docs.google.com/spreadsheets/d/1xrS8_Lcuqt3rLJgEkV4SHR_XTyGCAn8t9dJyWIUtMJ0/edit?usp=drivesdk

So it will read columns B & C, Everyday > Groceries on the Statement sheet and that amount will automatically go into the Expenses sheet in the correct place. And also read the date and put it in the correct month column.

Answer 1

Check this sheet (Make a copy for full access)

Note the Helper Pivot tab, which is referenced by formulas in Expenses tab. You can hide that tab in the final spreadsheet.

The formula =iferror(GETPIVOTDATA("SUM of $",'Helper Pivot'!$A$1,"Category",$A3,"Date - Month",text(D$2,"MMM")),0) can be copied/filled right or down as you wish inside the Expenses!D3:O range.