Is there a way to link my summary table back to the individual pivots?

[saraapple]

I have created the following table

CustomerId	CustomerName	SENT ITEMS	RECEIVED ITEMS	Missing	% RECEIVED
aaa	Sara	44	0	44	0%
bbb	Bob	10	0	10	0%
ccc	Craig	17	0	17	0%
ddd	Ryan	2	0	2	0%
eee	Glyn	2	0	2	0%
fff	Manchester	61	2	59	3%
ggg	Chester	64	5	59	8%

I want to be able to click on column E "missing" and be linked to the detail of the missing items - this information is in a pivot table.
I have around 100 pivot tables one for each supplier.

I hoped it would be as easy as left clicking and linking to the correct table - but excel does not like this and I am really struggling!
I have the data.....its just so messy and time consuming to extract, so any ideas would be most appreciated.

Thank you for taking the time.
Sara