If or statement in excel that has 3 options

I want to display data from 3 seperate cells in one sheet in a single cell in a different sheet in the same workbook. I believe it would require an if or statement but not sure how to write it.

Example: if B3 has data, then both B4 and B5 will be blank and the cell in the other sheet will display the B3 data

Example: If B3 is blank, B4 has data and B5 is blank, then the cell in the other sheet would display the B4 data

Example: If B3 is blank, B4 is blank and B5 has data, the cell in the other sheet would display the B5 data

How do I go about writing this function?