How to make a Booking Planning-report

Hello forum team

I want to make a booking/reservations report based on excel and I want it the following way;

On my excel book I have a "bookingList" and "Planning". on the BookingList are listed all the bookings received. After inserting this data, I want a planning which could display all bookings by apartment.

I want to fill "planning" sheet automatically based on the bookinglist sheet, this to be showned, for exemple, all bookings listed, on "bookingList" Sheet, for apartment C1A, to be showned on "planning" by apartment and for the dates occupied in the same row. i.e., fill "planning" sheet based on all bookings in "BookingList" Sheet.

Hope this is sufficient info.

Many thanks for all help that can be provided