Find formulas (or errors) in hidden tabs

I have a shared workbook of weekly reports which has over 30 hidden tabs. Tabs are hidden so that only the current week's data is visible and the following week, that tab would get hidden and next week's tab would be visible and so on.

Recently I've come across a message that there is a formula error somewhere in the workbook (see screenshot).

How can i find which page has a formula / error in a workbook that has hidden tabs please, without having to 'unhide' every single tab?

thank you

Thanks WK9128

Tried it but got a 'Run-time error '1004': No cells were found' message.

I'm a beginner in VBA so i've copied and pasted the code in and 'run' it.

Am I doing something wrong?

Thank you, that did work and I had a message that 'No formula errors found in hidden tabs'.

But when I close / open the document - I still keep getting the original 'circular references' message I posted about. :-(

To resolve circular references, you can follow these steps:

Identify the cell(s) causing the circular reference. Excel usually displays an error message with the cell reference(s) involved.
Determine the correct formula or value that should be in the cell(s) causing the circular reference.
Change the formula or value in the cell(s) to remove the circular reference.
Verify that the new formula or value achieves the desired result.
By fixing the circular reference issue directly, you should no longer receive the error message when closing and reopening the document.