I have a financial planning workbook with 30 sheets. The book has a table of
contents that is created manually by pulling info from cell A1 of each sheet.
However, we hide certain sheets depending on the situation. The sheets that
are hidden in any given situation is unpredictable.

Is there a way to automate pulling data only from the unhidden sheets and
then putting it onto a table of contents page?