Active cell

Hello.

I'm wondering if there is a formula that will do the following:

I've got 3 sheets. 2 for data 1 for a Summary.

I need something that will if either of the 2 sheets has a cell occupied by text then it will show in the summary sheet.

EG.

Sheet1 in cell A1 has the formula (Summary).
Sheet2 in A1 is blank
Sheet3 in A1 has "Test" in the cell.

So Sheet1 should show "Test".

IF

Sheet2 in A1 has "Done" in the cell.
Sheet3 in A1 is blank.

So Sheet1 should show "Done".

Is this possible? if so could someone show me.

Mike.