Need assistance with linking source data to a cover sheet

[KeithLogan]

I have a spreadsheet that has a cover sheet that pulls data from multiple different sheets with a bunch of different formulas. The cover sheet only reflects the data that has been selected from a dropdown box at the top of the sheet. I am looking for a way for a user of this spreadsheet to easily be able to view the data that was used by moving them to the source spreadsheet and either automatically highlighting what source data was used, selecting just what was used, or directing them in a way they can move through the data. Below is a basic example of what I need:

Below in sheet 1 there is a drop down list next to the TAB cell that allows selection between A, B, C, or D. I have shown the data that shows with each selection separated by lines

SHEET 1 A SELECTION

TAB	A
TOTAL	1
YES/NO?	YES

<tbody>
</tbody>

___________________________________________________________________________


SHEET 1 B SELECTION

TAB	B
TOTAL	2
YES/NO?	NO

<tbody>
</tbody>

___________________________________________________________________________


SHEET 1 C SELECTION

TAB	C
TOTAL	3
YES/NO?	YES

<tbody>
</tbody>

___________________________________________________________________________


SHEET 1 D SELECTION

TAB	D
TOTAL	4
YES/NO?	NO

<tbody>
</tbody>

___________________________________________________________________________



Listed below here is the data located on each of the sheets that the cover is pulling from. The cover grabs the data from cell A5 on each sheet (the total cell) and B1 where I just says YES or NO.




___________________________________________________________________________


SHEET 2 (A)

1	YES
0
0
0
1

<tbody>
</tbody>

___________________________________________________________________________



SHEET 3 (B)

1	NO
1
0
0
2

<tbody>
</tbody>

___________________________________________________________________________



SHEET 4 (C)

1	YES
1
1
0
3

<tbody>
</tbody>

___________________________________________________________________________



SHEET 5 (D)

1	NO
1
1
1
4

<tbody>
</tbody>

___________________________________________________________________________



So to further on my example, if someone has A selected from the drop down on the cover sheet and wants to know where the YES came from, is there any way for them to be able to click a hyperlink, button, or anything like that that will direct them to Sheet 2 and automatically highlight cell B1? Or select cell B1? Thanks in advance for any assistance provided!