one option is to download a fee addin named 'explode' from Aaron Blood's website

http://www.xl-logic.com/pages/explode.html

this gives very good cross worksheet auditing and isn't too difficult to use.

Mike