Apr 24 2022 10:33 AM
Hi I want to take four sheets and have what I type on each end up on one page. I can only link one set of cells to my catcher page. How can i set links from multiple pages in the same cells to go to the same catcher page.
Apr 25 2022 12:29 AM
Hi @zblaszczyk
most likely you cannot achieve this with formulas. I propose to use Power Query for this.
Simply spoken, you would load every single sheet that you want to combine into Power Query, which creates in your case 4 queries (menu "Data | From Table/Range").
Within the Power Query editor, you would merge or append these queries into one and load that final one into your catcher page.