I have a vlookup that goes out to another file.

Because the other file has several worksheets it is only searching on the
worksheet that was selected is there any way to get the vlookup to look at
all the worksheets within a workbook.

Here is my statement.
=VLOOKUP(A19,'[New Monthly Invoices June 05.xls]Aug 05'!$D$1:$S$2,16)

It works fine, but only for the Aug 05 Sheet within the other workbooks,
please help me to search the entire workbook for this.

Thanks,

JJC