How do I pull data from one Excel sheet to another in the newest version of Office 365?

[debbrindley]

Ok I am in school and my Excel project is to move data from one Excel spreadsheet to another using data connection, however, the class has an example and instructions of an older version of Excel. I cannot find on You Tube video with my current version which is the latest since I have a subscription to Microsoft 365. I am going crazy trying to figure this out. I finally found the drop down, but it is really super confusing.

 

[RasGhul]

Power Query has been in excel since 2010, a very easy and power tool for creating a connection between sheets.

How to use Microsoft Power Query

 

[debbrindley]

Power Query has been in excel since 2010, a very easy and power tool for creating a connection between sheets.

How to use Microsoft Power Query

Yes, but I have to use this method I mentioned above for my project in my class. But thank you.