Create IMPORTRANGE function much like google sheets
I don't see an equivalent of Google's IMPORTRANGE to index data live from another workbook.
I understand that Microsoft has brought this in and it is rolling it out.
See this link : https://techcommunity.microsoft.com/t5/excel-blog/workbook-link-support-coming-to-excel-for-the-web/ba-p/1590314
This function does not exist in microsoft online at this moment. I really hope create this function soon. One more point to GSuite