The primary benefit of Append is to help you create an historical record of source data. Using Append you can track changes to any variable over time (e.g, stock prices, temperature readings, etc).


Consolidate enables you to pull multiple source sheets into a single destination sheet to create a unified master database. 


Did this answer your question?