How to automatically copy data from one Excel tab to another tab (same worksheet) in Sharepoint

[Serenalip]

Hi there.

I have uploaded an Excel sheet to Sharepoint and I'm trying to find a formula to automatically copy data from one Excel tab (tab 2) to another Excel tab (tab 3) in Sharepoint but it doesn't work. I am finding that the formula's that usually work in Microsoft Excel don't work as soon as it's uploaded to Sharepoint. Any ideas?

[#2]

@Serenalip 

SharePoint Online & Excel Formula Reference (microsoft.com)

once you upload it in sharepoint the formula references change to a url. see link