Vlookup from another open book with partail name and search through all sheets

[shahdelsol]

I am trying to use Vlookup from another open workbook that its name changes everything I get it. The name of book starts with "New Book Pricing" and date. Since the date is always changing I wouldn't know what it would be. Can I reference to this open book just by partial name which is "New Book Pricing..."? The other issue I have is to look through all sheets from that book. So let's my look up value is A1 and let's say my table array is A1:P150 on all sheets on the book with partial name of New book pricing and index is 2. Can anyone help? Thanks