Search multiple spreadsheets

OK...so here is one with mock data in the first 4 months. The search page looks just like the rest of them except I want to be able to type in any name (under inmate) and have the search results pull up all corresponding data for that name. Not sure if it can be sone in that format or if I need to change it slightly...