Check a column for text. If text exists on a row, generate a list using corresponding cells from the row (across multiple sheets)|General Excel Questions & Answers|Excel Forum|My Online Training Hub

I want a formula that checks if any cell in column E contains any text at all. If it does, I want to output the information in cells from the same row.

So if E4 has text, I want to output the information from A4 and B4. I'm looking to create a list of names (last name is in column A and first name is in column B).

I figured out how to get a list of last names on a single sheet using =unique(filter(A2:219, E2:219=J1))

In J1 I placed a value I wanted to check column E for. There's two problems with this: 1) Most importantly, I cannot get this to work over multiple sheets and 2) I would like to check column E for any value rather than a specific one (though I can work around this if I can just get this to work on multiple sheets)

Any help would be much appreciated!