|I'm not clear on what you are trying to to do.|
1. I have to select the xml tag(Country) from Column A of sheet3 .
What do you mean by "select the tag"? In Excel to "select" something means to click in the cell or on an object or click and drag to highlight ("select") a range of cells.
4. update the status (i.e where tag found or not found) in Column B of sheet3.
Do you mean that you need to put an X or a Yes or something like that in Sheet3 Column B if the value in Sheet3 Column A is found in a specific column in either Sheet1 or Sheet2?
Couldn't a VLOOKUP statement do that for you?
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.