Formala for pulling values from another sheet where multiple vlookup search results exist

Hi

I was hoping to get help in creating a formula (e.g. vlookup, or something else) for pulling in values into a sheet where the date matches the search.

However, the issue I have is that multiple dates can exist.

I have created a sample sheet. So, if I enter a date in the "Input date" sheet, I'd like details to be filled automatically with a formula in the "Job 1", "Job 2" and "Job 3" tabs, by pulling data from the "Bookings" tab.

E.g. if I was to enter 1 October 2022 in the "Input sheet" date, how is it possible for George's details to come on "Job 1", Sally's details on "Job 2" and Adam's details on "Job 3"?

Many thanks!

Thanks very much Glenn.

Is there a way to match the columns, (like an index match or something?), e.g. in the attached updated sample, in the "Job 1" tab, I have some empty rows between row 9 and row 12. I'd like the result to show for "booking order 1-3" at cells C12:C14, but only when there is something ordered, as shown in the "Bookings" tab?

Thanks again Glenn.

Sorry, I was hoping for some formula (if possible), to match against the field being searched...

I've attached a new sample. As you can see, there are some fields in the "Bookings" sheet that shouldn't appear in "Job 1", "Job 2", "Job 3" etc.

I also have some empty rows in the "job" sheets between Booking order 1, etc.

Is an index/match or some other vlookup/hlookup/aggregate formula possible to achieve this?

Thanks in advance!

No other u-turns planned :P

Thanks very much Glenn!