How to transfer data from the 'Logbook' into a 'Timetable'

Dear Friends,

I need to make the following table:
- on the first sheet there will be logbook with cash inflows and outflows from and to different sources/hosts and the respective dates
- on the second sheet there is a huge vertical table with each day as a different row and all the sources/hosts as column headers

I need the values from the logbook be transferred to the second sheet to respective column and row, while other cells remaining zeros.

The example of what I am doing is in the attachment.

The problem is, this should be a formula for the whole column, which might include daily rows for many years. This is why the formula must be simple and not over-calculated.

Thank you!

If you use an excel table then formula's will be adjusted to fit length to actual data and will avoid selecting enormous ranges

see attachment