I have been asked to help revise a very complex workbook that has 25 sheets filled with named ranges, formulas, etc. As one of my first steps, I want to figure out which sheets are dependent on other sheets.

Does anyone have sample code that checks for references across all worksheets in a workbook?

Eventually I might actually want to build a table of each individual reference, but for my first step I just want to generate a list of dependencies at the worksheet level (WS1 relies on WS3 and WS4; WS2 relies only WS1, WS5 relies on WS1, WS2, and WS4… that sort of thing.

Do I need to check every used cell, parse the formulas and match against all worksheet names? Or is there an easier approach?