Lookup or index database type project?

In my mind this is probably a hard project. In most of yours though . . .

I want to create a list of hyperlinks in column A.
Row 1 will have a list of headers / categories
In columns B through Z I will simply place an "X" at the intersection of the link in column A and the category it would fit in across Row 1.

Now, on sheet 2, I would take the first category & it will list all the hyperlinks in sheet 1 column a that have an x in that category.

Sheet 3 would do the same thing with the next category, etc.

In the end I can add a hyperlink to the bottom of sheet 1, check off the categories it fits in, and it will populate the sheet for that category.

I have tried varying combinations of MATCH, LOOKUP, OFFSET, INDEX, etc. Of course, I am sure I did not do the right combination or typed it wrong, etc. (I know enough about Excel to know that I don't know much).

I tried IF statements & could get it to list the hyperlink, but the hyperlink would be text, not a hyperlink. Also, I could not get it to dynamically sort so that I don't have 50 blank lines between each link, etc.

The finished product will have approximately 400 hyperlinks and 40 - 50 categories. Also, the hyperlinks are to web sites.

If anyone thinks this could be done without too much hassle, please let me know. If it is too complicated, let me know that also & I will try something else.

My sincere thank you to anyone helping!