launch on double click - macro help!

[bluepenink]

Hello

Can i pls get some help with on worksheet before click change macro?

Basically, I have revenue by 2 criteria
1) by town
2) by revenue type (auto, purge)

i have my data in column D52:D64 in worksheet "cook county"

however, i would like to double click on any figure in range D54:D64 and it takes me to worksheet "chicago-2011" and the data is sorted by only "town" and "revenue type" that make up that sum?
i.e. if D54 = $100,000 on worksheet "cook county"
when i double click on D54, i want it to take me to worksheet "chicago-2011" and show all the accounts by town that sum up $100,000

can u pls help! ive been struggling....

*see file below*
https://skydrive.live.com/redir.aspx...7Z9ug0JH*98%24​

 

[bluepenink]

any suggestions guys? thx u

 

[bluepenink]

hello all

any suggestions?!