Microsoft Excel Tips and Tricks
Reconcile & consolidate data from multiple worksheets automatically using this amazingly simple Excel trick. You can set up a repeatable process so that every month Excel automatically combines the data for you.
Credit Chandoo