If you could create a named range containing the data on the 5 worksheets,
you could use something like VLOOKUP.

"Jurassien" wrote:

Hello,
Can anyone assist me in finding out what would be the best way to search for
a matching value within 5 different worksheets simultaneously?

Thanks,