Daily Excel Cashflow Tracker

I keep a running list of every expected cash-in and cash-out in a single Excel sheet. One column stores the Estimated Disbursement Date, amount and currency; another holds the Estimated Payment Date, amount and currency. I now need a second tab that automatically reads this source data and, for each calendar day, shows totals to be paid out and received, broken down by currency (USD, EUR, GBP).

Key points to respect
• Dates must display and be interpreted in the MM/DD/YYYY format.
• No currency conversion is required—simply group and sum the raw values in their original USD, EUR or GBP buckets.
• Whenever I add, delete or adjust rows in the source tab the summary must refresh without manual intervention (a combination of dynamic ranges, pivot tables, Power Query or VBA is fine as long as it updates at the click of Refresh or on workbook open).

Deliverable
An Excel workbook containing:
1. The automated day-by-day cashflow summary tab with separate columns for Cash In and Cash Out for each of the three currencies.
2. Any supporting queries, named ranges or macros fully integrated and commented so I can maintain them later.

I will provide a sample of the existing data layout as soon as we start; you simply need to wire up the logic and present the clean daily view.