Originally Posted by baileyn3

I have 21 sheets that are all identical filled with part #'s and data to go with those part numbers. On each sheet there are 4 shifts. For each shift, including the part number there are 9 cells side by side. I would like on another sheet to set up some kind of lookup, that when I type in a partnumber in cell A1, below that it will sit out all the times that the part number has been run regardless of which sheet it is located on. Is there a way I can do this?