Is there a way to automatically update(including deleting) items in a
list in one site collection from multiple lists in other site
collection?
Could workflow do this? I was thinking it would work well if I could
set up some rule for each of the input lists that if I added an item it
automatically added the item to the main list as well as if I deleted
an item it automatically deleted it from the main list.