How to drill across multiple tabs(worksheets)

[sivakr4056]

Hi,

I have one excel it has 2 tabs

first tab has all data in column A(all are unique rows).
ex:
column A
A
B
C
D

in second tab column c has few rows(these rows are just part of first tab data)
Ex:
Column C
C
D

my requirement is , if I select row D in second tab, I want to go to first tab automatically and display only D row.

please suggest me how can I do this

 

[sivakr4056]

Anyone help me how can I get this done