How to filter rows in Excel table using specific parts of text present in all rows?

Question

Hey there, my question is a little complicated to explain. But I will try my best.

I have to keep a track of my tests and progress so I have made a table in Microsoft Excel which has rows being used for 'Test No.', 'Date', 'Total Marks' and 'Marks Scored'. Now I want to add another column called 'SYLLABUS' and use it for noting down all the chapters which were asked in respective tests. And I want it to be in such a way that entire syllabus of a test should be in one cell. Then I want to create another sheet in the same workbook in which all the chapters will be given separate cells. And when I click any particular chapter, it should take me to my original table (something like a hyperlink), and those particular rows should be highlighted where that particular chapter is present in the newly made 'SYLLABUS' column.

This would help me to easily keep a track of the fact that which chapters were asked in which tests. I am unable to understand that what to search on the internet for my problem as I am very new to Microsoft Excel. Please help me in creating the new column 'SYLLABUS' with above mentioned conditions.