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

--
Jacob


"OceanSS" wrote:

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