Creating a separate list dependant upon a criteria in another list

Hi All,

I have a main list I maintain on spreadsheet. However, I want to create a new list (which is only partial of the main list) that automatically updates itself dependant upon a criteria.

For instance, if the third column ( A yes or no column in the main list) is a yes, then it adds the entire row from the main spreadsheet into the new list. (I know I could alternatively filter the third column in the main sheet and then manually copy and paste this into the secondary list, but I'd prefer if this was done automatically).

The end goal: fill out the main sheet manually, but if there is a 'Yes' in the third column, then it also adds this row into my secondary list.

The reason I need a solution to this is that there is actually multiple main lists, and only one secondary list.
Thanks for any help in advance!

Index match array can do that for you automatically.

Apologies for the slow response.

There is still some element of manually entering in the formulas with index match, isn't there? This becomes particularly longer when considering that I have multiple worksheets and only one list I wish to automatically update dependant upon the other multiple sheets.