I have a workbook that has multiple sheets with different information in each
sheet that needs to move to new results sheet contained in the same workbook.
I need to take the following cells c9 e9 g9 i9 c10 e10 etc from the all of
the
sheets contained in the workbook (108 sheets in total) and put the results
of the cells into a new sheet going accross the page. The following sheets
have the data in the same places as the first sheet c9 e9 g9 etc. but the
results need to be placed in the next line(s) down so that none of the
information is overwritten and is displaying all of the sheets in one sheet
in the workbook. Would a formula or a macro be better for this
and what would the formula look like ?

Cheers Shaun