Hey, everyone,
First of all, I apologise if the question has already been asked or is not basic enough.
I have a database .xls at work, the sheets contain tables, each on its own topic. All tables are of identical design and the last column is a 1/0 marking column.
I want to add a table of contents on the first sheet, with the following functions:
• all the other sheets represented, with a hyperlink to each respective sheet (already done, albeit the hard way - new hyperlink-> choose sheet, title-> ok)
• I want every row marked with a 1 to be automatically copied into the first sheet under its respective topic, making the sheet a Table of Contents/Summary Report hybrid.

I'd be surprised if it couldn't be done, since Word has a very convenient ToC function, but the Excel of the same MS Office edition doesn't.

Thank you!