cash flow statement

[petkaml]

Hello
I have little problem
I have three worksheet with cash flows, income, outcome and balance (initial) for four different branches. The cash flows are sorted by days in month. e.g.
initial balance 200
1.2. income $100
2.2. income $ 200 in one sheet for one branche

initial balance 100
3.2. income $50
4.2.outcome $100

how to make one cash flow statement for whole company divided by date
with collums date initial balance income outcome total balance for 1.2.,2.2.,3.2....and othe days of month
somethink with multiple sheet pivot table?

thank you