How to search a column on one sheet for text and display it on another sheet.

[nje]

Good Afternoon
I've got 3 problems I've been trying to solve for the last 7 hours, I think they are all relatively simple to those who know what they are doing but I've exhausted my excel for dummies and every formula I have taken from this siteand tried to adapt.
Obviously I'll post each problem on a different post, so here's problem one.
The sample is attached. It will consist of about 35 sheets, each documenting the hire of a Motability scooter or wheelchair.
On each sheet column P will identify any review dates.
What I would like is: On the Master page in Column C next to the relevant sheet name is for it to display any 'Review' that is flagged up, so that the user can have an overview.
There will only ever be one 'Review' per sheet, I can only get the master page to show it by referencing it to one cell, I can't work out how to search the whole column.
Thanks

[NBVC]

Try:

=LOOKUP(2,1/(INDIRECT("'"&B3&"'!P5:P36")<>""),INDIRECT("'"&B3&"'!P5:P36"))

copied down

[nje]

Thank you very much, that works brilliantly, I don't understand how it knows which sheet to look at but when I copied it down it worked, very clever.
I have just gone back to check something and noticed a slight problem though.
The 'review' flag in column P can be dismissed by inserting the end number e.g. 3 from the Review3 into column Q.
When you do that and go back to the master sheet it shows N/A can anything be done about that?

[NBVC]

What do you want it to show instead of N/A? A blank?

If so try:

=IFERROR(LOOKUP(2,1/(INDIRECT("'"&B3&"'!P5:P36")<>""),INDIRECT("'"&B3&"'!P5:P36")),"")

[nje]

Your'e a genius (and a mind reader) I did want it to be blank and that's what it now does. Thank you
Having studied your formula I now understand how it identifies the different sheets.