Vlookup several sheets in another workbook

Wow that really helped!

I have another query now, similar to the one above. This relates to our Purchase invoice board.

All of our invoices are internally numbered, the info is entered onto the attached spreadsheet. A register, source of all Purchase information. (this sheet was not created by me by the way, its really old and my manager does not want to change it )

I would like to create a spreadsheet of the invoices that i have placed under query, i have set out a simple template at the moment which i use. But i have to input all the info from the invoice on this sheet, I can't help but wonder if the vlookup functon would work on for this.

I would like to enter our internal invoice no into my query spreadsheet and with the vlookup function i would like to retrieve the info from our purchase invoice spreadsheet

Only thing is, our invoice num are continously rolling throughout the year. New numbers are not created for the month, it continues from the last invoice number. However our invoices are filed on a monthly basis (hence the month tabs below).

Is there a way that a lookup function can be retrieve info from several worksheets at the same time in a different workbook?