Interactive Table of Contents

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!

Hi VicDor

Welcome to the forum

No one else seems to have picked up on this - so I thought that I would have a go. I am not aware of any ToC, so I have written a macro.

I hope it does as you want

Regards
Alastair