Complex workbook quality check

Hi I am trying to develop a macro to check complex formulas in my financial due diligence data book and flag those errors as tab name, cell reference, error (formula not consistent in row, annual column sums wrong monthly columns etc). Although the vba is catching the formula errors it is still facing issues when analyzing complex tables in my excel. What would you guys suggest I should do to add the best formula checking conditions in my BBA