I have a workbook with a number of source sheets that feed into a
destination sheet on the same workbook. I want to be able to insert and
delete rows into the source sheets and have those changes replicated on the
destination sheet.

It works if the destination work sheet is in a different workbook and that
workbook is located on a different device on the network.