i have data in 10 different sheets (Sheet 2 to Sheet11)with identical columns.
i need to use the vlookup function in Sheet1 taking the range from column E
to H from each sheet.

Is there any tool whereby i can make te vookup function once for all sheets
and need not to use it for 10 times.

regards