Need help with VBA code to copy cells for certain values onto new sheet as headings

Hi all,

I've been searching online but only found some youtube videos to copy rows from one sheet to another, rather than what I am trying to achieve.

So I have a table like below:

table.PNG

and I want to setup a macro/code that will create headings on a new sheet using cells from column A but only if they have a "y" in column B

so for example, using the above y's from the above table, the macro should create headings on new sheet like below for those rows with y's:

'y' headings.PNG

I hope that makes sense, and someone can help,

Many thanks,

Ralphie



Test file attached below with table and example tab of desired result

Book1.xlsx