Import values from a cell or a range of cells
 

Hi,

I have an excel sheet named "Defect Log" in various folders that captures
defects for the document in that folder. This log calculates the Defect
Density using a formula.

My question is that at the end of the month, i have to get the defect
densities from each of these defect log, collate them and make a graph... so,
is there a way that we can import the value of a particular cell or a range
of cells to a new worksheet?

Thanks and Regards,
Sri Harsha Kiran.P