In that case, your destination worksheet is hardly 'static'; it's actually more dynamic than the others.

What happens when data from the source worksheets are edited/deleted after the destination worksheet has been updated?

What is the output order for the destination worksheet (e.g.: by complete source worksheet, meaning new row must be inserted and everything shifted down every time a new row is added to any but the last worksheet; or by source worksheet row, perhaps even meaning blank rows may appear where a given worksheet has less completed rows than one of the others)?

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]