Reference Data From One Workbook To Another (Excel 365)

Hey everyone,

On Excel 365 is there a way to move data from one workbook to another? I feel like I've tried everything! I tried using the Power Query tool, checking in an Excel 365 doc to regular excel to create a formula then checking it back out as a 365 document, and searching online for answers. 

If there's any way on an Excel 365 document to reference information from another workbook that would be fantastic. It's pretty straightforward to do in the regular version of Excel. What am I missing here? Doesn't even need to be automatic, batch refresh is good enough!