If you have data spread out over multiple workbooks or worksheets you might want to have them all in one place on one sheet. Rather than having to copy and paste you can do this using the Excel feature Consolidate Data. This is a great feature and also allows you to link to the original data so that if it updates it updates in the new place too.

Here I show you how easy it is to do this and includes linking and not linking the data.