Unfortunately it only worked localy with both files open. It did not work with sharepoint-addresses ('h t t p s : / / domain . sharepoint . com /path/[database.xls]2022'!B3). I can not find a solution of replacing the tab name 2022 with a value.

But it's a great solution for certain circumstances.

PS
Sorry! I am not yet alowed to write a correct URL in my messages :D