Index/Match across sheets

Hi,

I have a formula which looks across multiple columns and it returns the text which appears first. E.g. in the example below it looks in T2, if blank it then looks in U2 and so on and so on.
=INDEX(T2:AC2,MATCH(TRUE,T2:AC2<>"",0))

I need a similar formula which rather than looks across columns on the same sheet I need it to look across multiple sheets within the same cell and return it if not blank.

e.g. I have 4 data sheets and a summary sheet. The data sheets are:

• North
• Aviation
• Marine
• South

Only data is entered on the “South” sheet in cell E7 in the exmaple – this is the only thing I need to return to the summary sheet.

Can this be done?

I have included an example

Paul