If you need to combine like-for-like datasets in several Excel worksheets into one table, don't waste time and risk making mistakes by doing this manually. Instead, use Excel's powerful Power Query ...
How-To Geek on MSN
How to set Power Query to refresh automatically in Excel
Stop relying on manual clicks and clunky code—let Excel refresh your queries automatically.
Some results have been hidden because they may be inaccessible to you
Show inaccessible results