How to search for a word on one sheet and display it on anaother

[nje]

I have attached a copy of my workbook.
I thought I had nearly finalised my workbook but have been told that some people like to book a particular mobility scooter in advance.
I don't intend to make any sort of calendar, because I wouldn't know how to but I have bodged together a method of showing a booking by using a 'countif and some coditional formats'
If possible I would like it to be a bit more professional and it would be fantastic if it could actually show the date it was booked, but that isn't my main concern.

On the Master sheet in column 'E' I have put a countif statement to search column C of the sheets which returns 1, I have then coloured the 1 white so it doesn't show. Then I did a conditional format, so that if there is between 1 & 2 in the cell it will turn blue. It works but could be improved.

Each sheet represents one motorbility scooter/wheelchair, but I suppose it could be booked in advance more than once.
What I would ideally like is for the master sheet to say Booked 1/2/13 or just the date would do. if an allowance could be made for multiple bookings just in case then that would be perfect.
Thank you

[Ace_XL]

In E7 use

=IFERROR(INDEX(INDIRECT("'"&B7&"'!E$5:E$39"),MATCH("Booked*",INDIRECT("'"&B7&"'!C$5:C$39"),0)),"")

copy down

See attached

[nje]

Fantastic, Thank you