I'm trying to help my hubby with work. He has about 100 worksheets, sometimes
more. Each worksheet represents a warehouse they have inventory stored in.
How would I searh each worksheet to meet certain criteria? Like for instance
this is how its set up
A b c d
count type size thickness
4 comp 4x4 4

Each warehouse (which is its own worksheet) has an undefined number of
records and its constantly changing as they add more and sell others. He
needs to like search ALL warehouses to say bring up the warehouses that meet
all the criteria, like all that have the Comp type in size 4x4 with a 4in
thickness. This way he doesn't waste the day literally searching all
worksheets manually. It needs to "meet" all the criteria that he has
specified. Like if its a comp type but size 2x8 with a 4 in thickness, then
he doesn't want to know about it... Basically when they sell it, with what
ever specifications the customer want, they need to be able to punch it in
and pull up a list of warehouses that have that exact material stored in it.
I have been trying to get this done but my knowledge of excel is better than
his but still limited. Can anyone point me in the right direction? I have
tried the Hlookup but can seem to get it on more then 1 sheet, so i think i
might need to use something else, i just don't know what.

Any help will be greatly appreciated.