synchronize worksheets with master worksheet

[oig01]

I have four separate worksheets named a, b, c, d which the data for
each one is combined in a fifth worksheet called master all on the
same workbook. I am trying to make it so when I update data from any
of the a-d worksheets the changes also update on the master worksheet.

 

[Dave Peterson]

This is fraught with danger.

Excel doesn't do this very well at all. And I bet no matter how much you
(anyone!) work on it, it would never work when you handed it to a user.

I try to keep all my data in one location.

If I need other reports based on that data, I'll use some sort of
filtering/sorting if possible.

 

[Guest]

If the data is perfectly aligned then you can do stuff on Sheet d like

=SUM(Sheet a!:Sheet b!A1)