Automatically summarizes entries from multiple sheets

Hi Excel Guru,

I already posted a similar question but I think the question is kinda broad. I will try to explain it clearly.

Every month transactions are recorded in each sheet, specifically the daily income and expenses. I have 12 sheets Jan - Dec. My main goal is to have a summary of all loans borrowed from January to December and it will be recorded on the 13 sheet name Loans. To give me a enough view how much are my receivables.

I have attached here the file so you have an insight what the table looks like, and what is the report I needed (see loan sheet).

Hope you could help me.

Thank you.

Mr. Richard Buttrey,

Please find my file, because the one I attached previously was the wrong file.