Excel VBA to Highlight Duplicates across a workbook

[Yoshii]

I am trying to highlight duplicates across a workbook of multiple sheets. Essentially we will be using it to track ID#s and I want to highlight the whole row if this ID#(value) has already been listed on any of the other sheets.

The problem is that i'm not good at all with VBA so i would need some feedback and help from you guys on how to handle this problem of mine

 

[Yoshii]

Or if i now would merge all the worksheets into one and i would create one more worksheet containing multiple cells in row A with different ID#'s i would want to locate in the first worksheet, The ID#'s i want to locate in worksheet 1 dose not have any specific row that it always can be found in, For example: It can be in row A1 or even G14. Would it be possible to trace the cells from worksheet 2 to worksheet 1 and highlight the whole row or just that cell that is containing the duplicate?