Do you only have data on row 6 of each sheet? Can you not combine the
sheets into one composite sheet, instead of having 16 of them?

Pete

On Jul 1, 8:30 pm, klafert wrote:
I am using a formula and it works, but only for sheet 1. The source workbook
has 16 worksheets. I need it to search all 16 worksheet to find a match. I
need to modify my formula so that will search the whole workbook.

FORMULA:

=INDEX('D:\GLOBAL X RAY\[customer price level4.xls]Sheet1'!$A6:$C6,3)