Extracting Multi-sheet values

[Guest]

I have many sheets with the same design, but on different "subjects". For example product1, product2, product3, etc...and I need to collect price-cell and 3 o 4 additional data from those products,into a summary-sheet. Is any easy way to create the summary-sheet and being able to repeat the formulas to collect the needed information?.

 

[Bob Flanagan]

Jorge, the Spreadsheet Assistant add-ins, available at
http://www.add-ins.com, has a feature that does just what you want. You
would preselect the sheets, then you would b prompted for the range to
extract and the destination.

Bob Flanagan
Macro Systems
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel

I have many sheets with the same design, but on different "subjects". For

example product1, product2, product3, etc...and I need to collect price-cell
and 3 o 4 additional data from those products,into a summary-sheet. Is any
easy way to create the summary-sheet and being able to repeat the formulas
to collect the needed information?.