search for a value through multiple sheets and return value in corresponding column

I have a value in cell Sheet1 E3.

I want to look for that value in Sheet2 column A. (range is A:C) If there is a match, then return the value from column C in the corresponding row.

If no match, then go to Sheet3 and perform the same act.
(Take the value in Sheet1 E3 and search through column A of Sheet3. If there's a match, then return the value from column C.

Let me know if you want me to try explaining another way