Excel Formula Help

I have an excel formula issue. I have a workbook with 14 worksheets. In sheet 1, I have UserId’s in column A. In sheet2-sheet14 I have other UserId’s in column A. I need to figure out how to notify sheet1 that the same UserId might be listed in one of the other sheets.

The column labels are for sheet 1: UserId, Name, Sheet2, Sheet3, 4, 5… under the column label (ex: Sheet3) I want it to display an X in a cell if the UserId exists anywhere in that sheet. I tried playing around with Match, Vlookup, Hlookup, and IF but I couldn’t get anything to work right.

Any ideas? I am using Excel 2007.