worksheets vlookups
 

I am trying to do a vlookup in a seperate file from the one that I have
opened.

My worksheet that I am looking up has several tabs that I want to be able to
vlookup on.

My current Vlookup statement is

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

and it works fine, but only for my sheet label Aug 05, how do I look up on
all worksheets within a workbook.

Thanks,

JJC