Copy Cells from multiple Worksheets in same workbook.

[OceanSS]

I have a work book with mutiple worksheets and would like to create a summary
worksheet of certain cells within the other worksheets. I now I can copy and
past each cell, but is there a quicker way? For example I would like to copy
celsl sheet1!C15 through sheet10!C15 into individual cells in the summary
worksheet

 

[Jacob Skaria]

Check out the below link by Ron de Bruin on copying a range of each sheet
http://www.rondebruin.nl/copy2.htm

 

[OceanSS]

Thank you Jacob

Check out the below link by Ron de Bruin on copying a range of each sheet
http://www.rondebruin.nl/copy2.htm