How to consolidate multiple Excel worksheet data

There are many interesting ways to consolidate data from multiple worksheets in Excel including the 'consolidate' feature but this copy and autofill feature is so simple that it can be used by anyone quickly and easily.