Referring to the summary sheet, I want to make 3 tables, one per month.

The current formula just reads every row of the data sheet, I would like each table (per month) to filter the results based on the chosen month.. does that make sense?

so hotel 1 and cell b5, I would like the return value to just show bookings for hotel 1 in june, then cell R5 will be the just for July....

So i try to ask how should the formula be written? perhaps the combination of the IF and VLookup is not the best, I just don't know