Search multiple spreadsheets

Hi. I am trying to figure out how to crearte a search function that will search 12 different spreadsheets and show the results in a 13th sheet. I need to create it in a way that some one could do different searches. The data I have is names and information to go with the name. I want to set up the name so I could search a name and see what pops up under that name. It's important that the different names can be searched. i would have tried this under MS Access, but I don't have access to MS Access. Is this possible? I thought of using autofilter, but that's only good for individual sheets. If my first thought isn't possible, is it possible to create a "live" sheet that will pull ALL the lines from other sheets (as they are added) so I can run autofilter on the "live" sheet?

Thanks.

-Dave

I thought of using autofilter, but that's only good for individual sheets.

Not necessarily true if you can accept using a macro.

If the layout of the 12 sheets are similar one could have a macro that loops through all sheets (assuming they are in the same workbook) and filters the result in a sheet then copy it to the master sheet before it moves on to the next sheet.

Still as jraj1106 suggest uploading a workbook will give you the best feedback.

Alf

Here it is. There are 13 sheets in it. One for each month and one 13th labeled "SEARCH" where I want to be able to set up some sort of search function that will pull from all 12 sheets.

Thanks.

-Dave

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...

I have no idea what a pivot table is.

I entered some mock data in the sheets labeled "January," "February," "March," & "April." On the search sheet I have the same subject headers and a search field. I want the search field to reference the column labeled "Inmate" and present the any lines with that name.

Thanks. Looks like this will do exactly what I was wanted. I appreciate the help guys! Thanks a bunch!