highlight duplicates from one sheet to another

[nair.harish]

I have 15 sheets with variable data and the sheet names keep changing which i normally consolidate using pivot tables using multiple consolidation ranges and combine it into one sheet. what I really want to do is if i highlight a particular line on the consolidated sheet, then the same lines have to be highlighted across the rest 15 sheets.
Is there a vba or a conditional formatting option to do this?

Well just to make things a little more clear, i have uploaded the workbook at http://www63.zippyshare.com/v/2660780/file.html, there are only 3 sheets (sheet name keeps changing and there can be upto 100 sheets at one time) in it with one consolidated sheet, and i have highlighted one line on the consolidated sheet which i have again highlighted on the others.

Now if someone could figure out a vba to make it happen automatically i really would be extremely thankful

I am using excel 2007.

 

[nair.harish]

The above code described works like a charm... If possible i needed a small adjustment to it. it currently looks at the range and selects only one line in the others, if theres more than one similar line in a sheet then it does not highlight the others.

Thanx