Using Power Query, this type of work is extremely painless and quick. What’s more it refreshes data in just a click when more files are added.