Thanks FDibbins for giving this a try. Looks like you misunderstood what I need help with.

My provided file shows every group has 8 sets of data or rows (Test 1 to Test 8). I only want to data for Test 1, Test 3 and Test 8 copied to a final table on the right.
I have manually copied this set of data for Group 1 as a reference. My real data table has more than 100 groups and growing so I like to know a way I can highlight the formuas/cells in Test 1, 3 and 8 from right hand table then drap them all the way down.

Please let me know if this is still not clear. thanks.

P.