Question: what is the difference between source and destination formatting?
Answer: Keep Source Formatting: Excel copies the formatting from the original cells and pastes this into the destination cells (along with the copied entries). Use Destination Theme: Excel formats the copied entries according the cell style applied to the destination cell range.