Excel Search Function Across multiple Sheets

I have a spreadsheet with multiple tabs (sheets). One tab (Donor Directory) is a list of donor names. What I'm hoping to do is find a formula that will auto-fill a cell directly next to the donor nam...