Consolidate Data to Master Finances Spreadsheet

I have a finances spreadsheet and itemise all of my income and outgoings on one tab. I have a separate master tab which shows the total amount spent on each category per month (categories include rent, groceries, clothes, etc.). Currently, I am having to manually input all values into the master spreadsheet. Is there a formula I can use in order for the values to automatically be assigned to the correct category on the master tab? Thanks!

Hi!

Check the attached file for solution.

Feel free to contact if you need any explanation.

That's perfect, thank you so much for your help!