Is there a way to display a pop up message box that references a cell range or table from another worksheet when you select a cell on the current worksheet so that the individual looking at the data can access more information without having to switch to the other worksheet?

As an example:
You have a lot of trailers waiting to be placed at a dock and get unloaded. On another sheet you have a list of what is in each of those trailers. Instead of having to switch to the trailer inventory sheet and then find the trailer to see whats in it, you could just click on the trailer number cell on the first sheet and a pop up window opens displaying the inventory of that trailer.

Is something like that possible? If so, Can someone point me to a creation tut or a youtube vid. My google-Fu is failing me today and I can't find anything.