Creation of an Excel sheet to summarise annual expenses.

I have an Excel workbook that list all my expenses by month (one sheet by month) and by account (bank account, credit card, cash). And I need to summarize all these entries in one table, where I can easily filter entries to create reports. The Excel workbook with all my expenses is "Bruno's Expenses - 2020". I also attached a demo of what I would like to achieve. Please have a look at "Bruno's Expenses - Reports - List all entries - 2020" sheet, with all requirements. The requirements are. 1 - This table must display all entries from "Bruno's Expenses - 2020" document (all months/sheets and all tables [UBS, Mastercard, Cash]). The entries displayed there are only for demo purpose. 2 - All fields from "Bruno's Expenses - 2020" tables entries must be displayed there (Date, Debits, Credits, Name, Description, Category, Subcategory, Group + Account) as in this demo 3 - There is an extra Account column (I) that is related to which table the entries are taken for (UBS, Mastercard, Cash) 4 - All filters (A2,B2,C2,D2,E2,F2,G2,H2,I2) must work as in this demo (especially Date, SubCategory, Category, Group and Account) 5 - We should be able to filter also by Account (I) 6 - The sum for Debits/Credits (B1, C1) must be conform to all entries displayed in this table and dinamycally adapt to the table filters (A2,B2,C2,D2,E2,F2,G2,H2,I2). 7 - Be careful, in the file "Bruno's Expenses - 2020", there are some rows used only for autocomplete feature (rows > 100). These rows should not be listed here 8 - All empty lines from "Bruno's Expenses - 2020" document should not be listed there. Only rows with relevant info filled (date, debits/credits, recipient, subcategory, category, group) should be listed there. 9 - The "sort by" feature must work as in this demo (using the filter pane) 10 - This worksheet must be compatible with Excel for Mac 11 - This worksheet must use index() and match() functions (avoid Pivot Table)