Hi Stnkynts,
you're absolutely right. I made a small mistake, and moved the sheet somehow and did not notice. It works perfectly. Thanks so much for all your help. I will try to come up with a code to enter page breaks and page numbers in the last sheet (sheet 1 in this case) and then combine it with the matching text (test) on the Table of contents, since I would also need to show page numbers. If I get stuck I will have to bother you again. Thanks again for all your time.