Values and Source formatting is the paste option for pasting the values keeping the formatting intact. The procedure carries on with a formula being assigned to whole column and value are to be collected from the every excel sheet for the formula to calculate the value and put it in the respective cell.