I have a workbook that has sheets for each days orders with some brief
information about each order. The first sheet "Tracking" has 2 columns
"ORDER" and "TRACK". They contain an order number and a tracking number for
that order.

I want set a cell for each order in each of the daily sheets to search the
first sheet for the order number. If the order number is found display the
corresponding tracking number. If possible I would like to to display Not
Shipped if the order number cannot be found in the first sheet.

I am not sure how to even go about doing this. I can provide an sample
workbook if it will help clarify what I am trying to explain.