While you can copy and paste data sets, if data sets are dynamic - it is very time consuming & potentially error prone to constantly copy and paste.
Microsoft have introduced a simple new formula - VSTACK - which is a simple and dymanic way to combine data sets in Excel.
See the attached presentation.