Not necessarily true if you can accept using a macro.I thought of using autofilter, but that's only good for individual sheets.
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
Bookmarks