help with VBA codes to extract selected data from worksheet on specific conditions

Hello to all

I am new to this forum so first of all "A very warm hello" and I really really apologise if i am duplicating this OR posting this into a wrong thread..

Now, i have attached a datasheet which has got lots of column. (see Sheet1)

Want i want to achieve is, I have got a button on sheet2 called "Sue Hendry". I want my users to click on the button and wherever (on sheet1), Sue Hendry on column Y has got "Y", i want it to retrieve all the data for that. which is from column A to column S

Is this possible?

Eventually , i want to have a button for each heading from column T to column AC and it needs to do the exact same thing.

PLease, any help be appreciated