Complex Excel Formula Help

Hello,

I have a complicated excel problem I'm hoping to get some help for.  I'm not sure if it's actually possible to solve, but you all are my best chance.

Platform: Excel 365

Problem:

I have an excel workbook that tracks Client's monthly budgets. Each month has it's own sheet. I also have a dashboard where I have created several charts that track certain datapoints as the sheets get filled out. I would like to create a table/chart/new sheet that automatically populates with several data points of client's if they chronically overspend their monthly budget by 20% or more.

Complications:

1 - Clients don't all start at the same time

2 - Budgets aren't the same

Considerations:

Can I make a table that automaticly  populates Column A, B, C, D, E, F if a client has overspent their budget by 20% or more for 3 months (not always consecutive)?

Would this be easier to dedicate a new sheet to?

Is there a way to make the remediation Column (N) say yes if overspending criteria is met, no if not met, but then feed that into a seperate table for remediation tracking?

Another option I'm not aware of?

I would be looking to have column A-F from the monthly sheets autopopulate into a new datatable for tracking remediation proceedures.