Findnig list of items in various sheets

Hi,

I have list of user id's in workbook1. I want to check whether the user id's are existing in workbook2 in various sheets(sheet 1,2,3). I dont want to give Ctrl+F and find whether the user id is existing in the workbook2. Bcoz i have 100's of user id's.

How to solve this and do this in once shot? Does it need any programming? Can anyone solve this for me?

Thanks in advance

You could try creating a filter

Data - Filter - Autofilter

This will allow you to pick who you want or you could try a vlookup. This can be quite fiddley so I would suggest that you strip out any details you don't want people to see and upload an example of what it is you are trying to do.