How to Automate Import of Data?

[BrettOlbrys1]

I have my file which contains lots of sheets, but only one DATA sheet drives everything.

That one DATA sheet is external data that I manually import into my DATA tab, which then drives the rest of the sheets. That one import file sits on a SharePoint site (which gets updated daily), and I was wondering if there was a way for me to click a button within my Excel file that would grab the file, read the data, and then import it to my data sheet? Basically, I want to automate the process...is this possible and if so, how do I do that?

 

[alansidman]

 

[Misca]

I believe Power Query is just what you're after. You only have to "teach" the query once and after that it repeats the steps every time you want it to. And best of all: No macros needed.