Someone is going to have to go through those macros to
determine the relationships, if thats the case.

If no one has that ability you will probably require the
services of an excel vba consultant, whom can be found on
the web.