Linking cells from multiple sheets to one catcher page

Occasional Visitor

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.

1 Reply

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.