[DerekM]

So... this should hopefully get you started. Without doing something much more complex, you'll probably need to change the structure a bit and put all projects in a section and then have a section for people and a section for types.

Then what you'd do is check all items in the different projects Some things that could be of use:

every row whose (level is 3 and topic of parent is "test")

tell (every row whose topic is "test")
set topic of every child to "bingo"

You know how to check the contents of a cell in a row so then you'll want to check if the row already exists in the other section and if not add it. As far as updating entries, would be easy enough to do if the name of the item didn't change, if it does, pretty sure you can do some referencing to match back to the row but that's beyond what I know how to do yet. You could also just erase all the additional sections and have it rebuilt by the script.