Copy row 21 from all sheets to a new sheet except " summary"

[Guest]

I have a spreadsheet for which I need to summarise "revenue data". This is on
row 21 on all sheets. There is also a "summary " sheet already in the
spreadsheet which I want to ignore but I do not wish to delete it..
I need my summary data to go on a new sheet called "Consol Rev". The consol
will take row 21 data from all sheets and copy to the next available blank
row. The number of sheets varies depends on which parameters are picked by
the user when running the report.

After I have got summary revenue data I need another macro to also summarise
"Gross Profit" data . This is on line 38 on all sheets. In my new "consol
GP" sheet I would need to take data on line 38 from all sheets except for
"Summary" and "Consol Rev"

 

[Guest]

see excel help - Consolidate data in multiple worksheets

 

[Guest]

hi..

thanks for the hint but i was looking for a macro.

thanks

 

[Ron de Bruin]

thanks for the hint but i was looking for a macro.

See
http://www.rondebruin.nl/copy2.htm