Both, the order will not be the same on all 3 sheets by a long shot... and the two reports use different names (darn departmental differences), so i will need to manually enter the search string for each cell on the reports to search the count sheet... eg if the formula is looking for widget 1 i would edit a formula to be something like this:

='count sheet' find 'widget 1' return value from "column labeled 'total on hand'"

make sense?

i will have to enter the 'widget 1' value by hand in each cell to match what i'm looking for on the count sheet