How to write a macro to automatically transfer data on certain conditions
===

It's my first time using this website and I'd greatly appreciate if someone could help me write a code for Macro in Excel to do the followings.

Situation:

1. I have 8 data sheets called "Data A", "Data B", ..., "Data H"
2. I have 1 summary sheet called "Summary"
3. On each of 8 data sheets, there are n number of IDs from C8 and on horizontally (i.e. C8, D8, E9, ...) 
4. Each ID has associated data under the cells vertically. (i.e. ID in cell C8 has relevant data on C9, C10, C13, C14, C15.)


To do:

1. Upon activating macro, go to Data A, start from C8 to check if the cell is empty or not. 
2. If the cell is not empty, copy the ID(a string and number combination) in cell C8 along with relevant data from (C9 to C10) and (C 13 to C15) onto Summary sheet at (A1 to A6)
3. After copying, move to the next cell which is D8 on Data A sheet, repeat step 2. This time, the destination of copying would be B1 to B6 on Summary sheet.
4. At any point, if a cell on row 8 on Data A sheet is empty, move to next Data sheet (Data B).
5. Repeat step 2, 3, 4 until an empty cell is found on Data H sheet
 
I hope I could find someone who would be able to do this. Thank you.