VBA code, select conditional formatting content and transpose Sorted to other sheet

Hi all !!


I'm still study VBA, and yes i learn a lot, but this sheet came to me and certainly i know how to do some stuff
and on mid of this there is a "missing link" (mentally speaking) that i don't know how to associated with Conditional formatting.

I'll ask you 2 question in one.

Question 1 : I'm asking for help to code for only 1 zone
Question 2 :what line of code do have to modify in order to include 3 zones, perhaps 9 zones ?

I'm doing this 2 question because of my learning, and i would like to know why and how lil things change when using VBA.
and also i want to apply by my self to 8 sheet with at least 50 zones in total.

Please i need help on this :
====================
-.Any Highlighted Numbers (i'm using 5) from Column A3 :38
that have "Y" on Column C3:C38 of Sheet "R-2" must
-.Transpose "A2" content Starting on Single cell "I5" of Sheet "T2" 
-.Transpose Sorted Highlighted Numbers "A3:A38" Starting on Single Cell
"J5" Sheet "T-2"

-.The Formats of Transpose numbers to Single Cell can be with "," or "-" and Sorted
example:
3-5-13-24-28 (Please see Sheet "T1 ")
3,5,13,24,28

Next step
=======
-.If The "Y" from Column C3:C38 (Sheet R-2) are removed and Place new sets of "Y" to select new sets of numbers,
Then
-.Transpose "A2" content to next Available Single cell "I6" of Sheet "T2"
-.Transpose Sorted Highlighted Numbers "A3:A38" to next Single Cell
"J6" Sheet "T-2"

"R2 " Sheet Specs
==============
-.This Sheet have 9 Zones, (27 columns)
-. Each Zone have 3 Columns, (example in Zone 1 (A3:38, are linked to C3:C38 trought conditional formatted.)
-.First Column zone 1, A3:A38 Have numbers from 01 to 36 where
Numbers get highlighted If in 3rd Column C3:C38 i type the Letter "Y"
(formula used in conditional formatt is : ISNUMBER(SEARCH("Y",C3))=TRUE
-.2ND Column "Score" (B3:B38) i use as a reference, is not Important


what this sheet do :
===============
-.If in zone 1, anywhere Column C 3:C38, i type the Letter "Y" , (no quote) 
e.i in Rows C3, C5, C6, C9, C11,
Then Column A with Numbers 03, 05,13,24,28 Get Hilighted .

Thank you a lot in advance..


Best Regards

David