I am using MS Excel 2003 SP2
I saw the Excel help example "About labels and names in formulas" which
explained how to use Column headers in a formula. I want to use this
functionality because the column headers remain constant but headers may end
up in different colums (ie "Product 1" may be in B1 or in B3).

Division Product 1 Product 2 Product 3
East 70 30 16
West 20 80 14
Total 90 110 30

the example shows the formula "=Product 3 East" with a result of 14 which
is what I would expect and this to works in my test spreadsheet. How do I
reference these cells from another worksheet or workbook. I get an error
when I try =Sheet!Product 3 East
Thank you
Anderson