I have 2 posting here, but everybody gets bogged down on the wrong part of
the question. My original ques ion is very similar to what I have seen
posted here, yet it seems to be a problem. Right now the problem is no the
formula I use except for I need to specific a range that includes using more
than one worksheet tab. Here is the formula it works for one worksheet
because I only specifics one worksheet. I just need to know how to encode
the range of the other worksheet tabs. first worksheet is sheet1 and goes
through sheet16 in the same work book.

=INDEX('D:\GLOBAL X RAY\[customer price level4.xls]Sheet1'!$A2:$C2,3)
How do I edit this formula to include the other worksheet.