what is need is something like:

=VLOOKUP(A2;'Sheet1:Sheet2'!A:G;5;FALSE)

but of course it will not work in such way. I jsut need the vlookup to
search not in one but ALL sheets and there are around a 1000, so instead of
repeating the function =VLOOKUP(A2;Sheet(1)!A:G;5;FALSE) on each sheet i
would like the function to go through all sheets at once)

Best Regards,

Pawel P.

(X) is the sheet number :-)