I can't figure out the best way to do this:
I have 3 input data sheets. Contribution info from 3 sources. Each has
difference sections of info. They want a 4th sheet that is the summary sheet
that adds all of the other sheets and is automatically sorted without the
user doing anything.
My boss wants to input data on any of the three sheets and have it
automatically appear in the correct place on the summary sheet.
I know how to link when the source is known, but how do you make new rows
automatically get added and in the correct alpha order on another worksheet??
I was thinking something like 3-D references and ranges.