Copy & Pasting Multiple Cells and Ranges From Each Worksheet To a Seperate Sheet

I have workbook that has several sheets within the workbook that are set up identical. Each of the sheets in the workbook are for a specific company (my actual workbook has 100's of sheets).
What I am trying to do is to populate an overview sheet with cells C24, C25, and B36 being static on each row per sheet. Then each row will be populated with cells C(36, 59, 70, 81), D(36, 59, 70, 81), F(36, 59, 70, 81), G, and H(36, 59, 70, 81). Everything from row 59 down is in increments of 11 (the actual data goes from row 59-840 in increments of 11). So row 36 to 59 is the only 13 row increment.

I attached an example of the data I am using as well as a visual below.
Thanks

Sheet 1 C25 C24 B36 D36 C36 F36 G36 H36 I36
Sheet 1 C25 C24 B36 D59 C59 F59 G59 H59 I59
Sheet 1 C25 C24 B36 D70 C70 F70 G70 H70 I70
Sheet 1 C25 C24 B36 D81 C81 F81 G81 H81 I81
Sheet 2 C25 C24 B36 D36 C36 F36 G36 H36 I36
Sheet 2 C25 C24 B36 D59 C59 F59 G59 H59 I59
Sheet 2 C25 C24 B36 D70 C70 F70 G70 H70 I70
Sheet 2 C25 C24 B36 D81 C81 F81 G81 H81 I81


What I have so far. Question for the code to make it easier (my actual workbook has 840 rows); Product 1 to Product 2 has 21 rows inbetween but Product 2 to Product 3 and Product 3 to Product 4 have equally 11 rows inbetween. Can the second with statement just include a reference to D, C, F, H, J, L, N59 and adding 11 rows to that until it hits a blank row?

Please Login or Register  to view this content.