|Keep in mind that we can't see your spreadsheets from where we're sitting, so it's kind of hard to give a specific answer.|
It sounds as if VLOOKUP would work, except the VLOOKUP doesn't work across multiple sheets.
However, there is User Defined Function at the Ozgrid site that will do VLOOKUP's across all sheets in a workbook.
Are you ready for a interesting coincidence? The example they use is:
=VLOOKAllSheets("Dog", C1:E20, 2, FALSE)
As I said, not knowing the layout of your sheets, but using the fact that you said that all sheets are laid out the same, I'm thinking that you might be able to use this UDF to accomplish your task.
Let us know if that helps.