Move selected cells to new destination via macro / formula / VB ed

[Guest]

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

 

[Guest]

as in :
sheet1 c9 e9 g9 i9 c10 e10
sheet2 c9 e9 g9 i9 c10 e10
sheet3 c9 e9 g9 i9 c10 e10

to sheet 4
row 1 (sheet1) c9 e9 g9 i9 c10 e10
row 2 (sheet2) c9 e9 g9 i9 c10 e10
row 3 (sheet3) c9 e0 g0 i9 c10 e10

 

[Max]

One way to set it up ..

In Sheet4
-------------
Put in B1:G1 : c9, e9, g9, i9, c10, e10
(these cell refs act as the "column" headers)

Put in A2:A4 : Sheet1, Sheet2, Sheet3
(these sheetnames will be the "row" headers)

Put in B2: =INDIRECT("'"&$A2&"'!"&B$1)

Copy B2 across to G1, fill down to G3
to populate the table

B2:G4 will return what you want

Adapt and extend to suit ..

 

[Max]

Sorry, some typos just detected ..
(but maybe obvious? <g>)

Lines

Copy B2 across to G1, fill down to G3
to populate the table

should read as: