What is copy area and source area in Excel?

The copy area and source area can both to refer to the cells that you are making a copy of. Another use of source area, is the cells used in the process of consolidation of data.