highlight duplicate values referring to another sheet

[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?

Kindly help.
Thanks

 

[nair.harish]

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]

help me plz plz...

 

[nair.harish]

someone please help me...

 

[nair.harish]

plz guys I really need some help here....

 

[nair.harish]

help...