Forum Discussion

Benni2024's avatar
Benni2024
Copper Contributor
Jul 21, 2025

Excel Linking Help

Hi I’m working on a spreadsheet at the moment and everything is contained within 1 workbook. 

I have a master sheet and different sheets with information that when updated need to link back to the master sheet - I have done this successfully using paste special so every time the content is changed in say sheet 1 it updates the master, however, I have been asked to sort it so that if a new row is added to sheet one it automatically picks this up in the master sheet, l believe this can’t be done without using VB or similar as when adding a new row surely the master will only pick it up if it’s added to the master also and linked back to sheet 1.

any help appreciated. 

community
excel
Formulas and Functions

1 Reply

  • Harun24HR's avatar
    Harun24HR
    Bronze Contributor
    Jul 22, 2025

    Yes, absolutely possible. You need REDUCE() and VSTACK(). Or if you have fixed number of sheets then only VSTACK() with FILTER() can do this.

    See this answer by me on another question.

Resources