Showing entries in separate sheets according to column criteria

Dear all

I am looking for the easiest way to make an excel-sheet that allows the user to see a selection of the entries in a gross list (one sheet), with a range of criteria in the last column.

E.g.:

Person A - Adress - Phone - X - Y - Z

Then I would like to have sheets X, Y, Z that list all the entries of the persons with a Yes in column X, Y, Z.

I think I need to code a macro and have a front page sheet, where the user clicks a "update"-button running the macro (which I understand in principle, but I don't know how to do it). Is this the case, or is there a simpler way of doing this?

Best regards,
gbnitram

Sample.xlsx

Great idea! Here is a sample file.

The idea is that all editing should take place in the gross list. (This in not practical, but I figured that it would make the task simpler).

This means that the sheets relevant, x, y, z should simply be replaced by the updated items in the gross list.

Thanks for your help!

Thanks, Arlette. That's absolutely perfect!!!

There is only one small thing I'd like to add. I've been considering the user interface, and it would probably be good if relevant, x, y and z were read-only so that people do not insert their changes and additions in the boxes that will be erased by updating.

I assume that I should add code before and after the script, so that it can add the values from the gross list? Or is the macro able to run even though I make three of the sheets read-only?

Again, thank you so much for your help. I would probably never have figured this out on my own.

BR, gbnitram